PanzerAttack
Board Regular
- Joined
- Jan 3, 2008
- Messages
- 197
How can I automate importing some files from Excel into Access.
The TransferSpreadsheet Macro Action doesn't allow me to select the range for some reason.
In Tables New - Import Table works perfectly
How can I automate this way of importing Tables to import 200 tables directly from Excel.
I found this
http://www.databasedev.co.uk/text-import-macro.html
which looks ideal but I can't see a way to save it when I Import Excel (no Advanced tab).
Any ideas? I'm sure I'm missing something obvious.
The TransferSpreadsheet Macro Action doesn't allow me to select the range for some reason.
In Tables New - Import Table works perfectly
How can I automate this way of importing Tables to import 200 tables directly from Excel.
I found this
http://www.databasedev.co.uk/text-import-macro.html
which looks ideal but I can't see a way to save it when I Import Excel (no Advanced tab).
Any ideas? I'm sure I'm missing something obvious.