Does anyone out there have a good code on converting an Excel database to an Access database with all the columns in Excel worksheet? Please post some code. Thanks!!!
Printable View
Does anyone out there have a good code on converting an Excel database to an Access database with all the columns in Excel worksheet? Please post some code. Thanks!!!
Sorry I have not done this myself, but since Excel and Access can both be set up as ODBC Data Sources, perhaps you could try accessing the Excel Worksheet as a DataSource rather than as a file (which might be why you are stuck?). In this way, the ADO data model will help you convert from one to the other by "hiding" the difference in formats.
Much easier if someone posts some code, but in case you are sitting there waiting... maybe this will keep you busy?
Cheers
Paul Lewis
Hey
I have a "zipped" project that converts an Access to Excel
if it may give you any ideas. But it should easy to reverse?
give me an address if you want me to send it to you?
William
Cool! My email address is [email protected]
Thanks William.