I have been using an Access program that reads data from an Excel spreadsheet using the DoCmd.TransferSpreadsheet acImport in VBA.
I now want to improve the application by writing it in VB6, but still need to get the data into Access from Excel? Is there an equivalent command in VB6 or could someone tell me some other way of doing it?
As a last resort we could always open the database, import, then close it and run the VB program, but surely there is an easier way than this!
Help much appreciated.
Stuart
I now want to improve the application by writing it in VB6, but still need to get the data into Access from Excel? Is there an equivalent command in VB6 or could someone tell me some other way of doing it?
As a last resort we could always open the database, import, then close it and run the VB program, but surely there is an easier way than this!
Help much appreciated.
Stuart