How do I convert an Excel spreadsheet to a database for use in my VB application? The spreadsheet is a series of about 10,000 records divided up into categories. Some of the cells in the spreadsheet are commented, and Id like to transfer these comments over with the data contained in Cells, if possible.
Converting Excel spreadsheet to a Database
- Thread starter rbulph
- Start date
PlausiblyDamp
Administrator
What type of database are you wanting to convert to?
Dont know really. Ive got the data in an Excel file currently and would like to distribute it in connection with an application. It would seem more professional to distribute the data in a database than in an excel file. I was looking at an example that uses an "SQL Server Database Primary Data File" so was thinking of that. But to be honest, my knowledge of databases is not that great. Maybe I should just put all the data in as project resources? The Excel file has about 10,000 entries.PlausiblyDamp said:
net pwanage
New member
- Joined
- Dec 12, 2005
- Messages
- 4
access is a good database since you already have M$ Office
to go about inporting your excel data into M$ Access first CREATE A NEW BLANK ACCESS DB. > ***i should note now that this is for Access 03*** anyway now go to FILE > GET EXTERNAL DATA> IMPORT> now just use the handy dandy browse feature to locate your Excel DB or any DB you wish to transform into Access. REMEMBER TO CHANGE YOUR FILE TYPES TO ALL > click IMPORT> the wizard will begin you can choose to import your current Excel columns into this database or just create new ones FIRST ROW CONTAINS COLUMN HEADINGS (you should just use the ones you already have)> you can also choose as the wizard moves along to what your Primary Key should be or you can have access create one for you> next> next> next finish. congrats you have converted legacy data into a very functional database for your dataset size.
-JB
to go about inporting your excel data into M$ Access first CREATE A NEW BLANK ACCESS DB. > ***i should note now that this is for Access 03*** anyway now go to FILE > GET EXTERNAL DATA> IMPORT> now just use the handy dandy browse feature to locate your Excel DB or any DB you wish to transform into Access. REMEMBER TO CHANGE YOUR FILE TYPES TO ALL > click IMPORT> the wizard will begin you can choose to import your current Excel columns into this database or just create new ones FIRST ROW CONTAINS COLUMN HEADINGS (you should just use the ones you already have)> you can also choose as the wizard moves along to what your Primary Key should be or you can have access create one for you> next> next> next finish. congrats you have converted legacy data into a very functional database for your dataset size.
-JB