Is there a way to look at the code behind an Import Wizard in Microsoft Access? If I use the TransferText method, I can create and save specifications but I cannot do that with the TransferSpreadsheet method. I need to use the TransferSpreadsheet method because the users will be importing data from Excel, not from a text file. I was hoping I could find a way to set specifications for the TransferSpreadsheet method like I am able to for the TransferText method. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import Wizard in Access
- Thread starter Jennie
- Start date
Similar threads
- Locked
- Question
