Is it possible to be able to write a sub procedure in VB6 automatically import an Excel 2000 spreadsheet into an Access 2000 table? The location of the spreadsheet and its structure will not change and the same applies to the table? If this is possible does anyone have some useful code that i could use. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to import an Excel 2000 spreadsheet into Access 2000 using VB6?
- Thread starter Gaff
- Start date
Similar threads
- Locked
- Question
- Locked
- Question