Maybe I could use that method. At least it gives me a starting point... Any code examples or info about those help
files would be much appreciated, thanks...
What I`m trying to do is import data from a Excel Spreadsheet (from all the worksheets at the same time, if possible) to an existing Access table using a "open file" - dialog box to specify the file...
I hope this clears it up... sorry my english is not perfect.
Does someone know is it possible to use standard windows
"open file" dialog box to specify the Excel Spreadsheet - file from which to import data instead of always changing the file name from the VB code? And how do you specify the worksheet using the TransferSpreadsheet (my xls-files...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.