I have to read in data from an Excel spreadsheet into an Access Database table during runtime. I used to get the file in a text format, and did the reading in using InStream. What method can I use to convert the data from Excel to Access??
Printable View
I have to read in data from an Excel spreadsheet into an Access Database table during runtime. I used to get the file in a text format, and did the reading in using InStream. What method can I use to convert the data from Excel to Access??
*bump*
Same thing here. I have an excel file that needs to go to access 97. Any tips anyone?
Thanks in advance :)