chrisbrocco
Board Regular
- Joined
- Mar 31, 2005
- Messages
- 82
Re: Importing from Excel problem.
Using this code how could I import in the same way but import all sheets within one book
Im having trouble importing a spreadsheet into access.
The sheet im trying to import has approx 15 columns, all formatted correctly, but whenever i try to import im only getting the first 2 columns.
Im using the following code to do this -
Code:DoCmd.TransferSpreadsheet acImport, _ acSpreadsheetTypeExcel9, _ "tablename", _ "my path", _ 1, _ "A1:U200"
ive tried doing the import using the wizard, and get the same results. Only the first 2 columns.
Anyone got any ideas?
Using this code how could I import in the same way but import all sheets within one book