want to create a database for my excel data?

3 posts · originally from https://geek.digit.in/community/threads/want-to-create-a-database-for-my-excel-data.89604/

hi

i have prepared a invoice template in excel for my business. now i wanted to know how to make a database so that everytime i use this template the data entered in excel is stored and so can be used to get different information such as history of invoices created material sold the total taxes etc. think it wud req vb programming in excel.
i dont knw any programming lang. an1 cud help me with it?

i too am interested in knowing. I know VB

raja2281 said:
hi

i have prepared a invoice template in excel for my business. now i wanted to know how to make a database so that everytime i use this template the data entered in excel is stored and so can be used to get different information such as history of invoices created material sold the total taxes etc. think it wud req vb programming in excel.
i dont knw any programming lang. an1 cud help me with it?

Hi...couple of questions..

1. What you want to do with your data.
2. What type of data base you want..MS Access...SQL..Oracle..???
3. How large are your data sets.
4. How is your current excel template structured.

Let me know..can help you out..for sure..!