![]() |
|
|
#1
|
|||
|
|||
|
How do I import multiple Excel worksheets within an Excel file into Access 2003. I am building a master table in Access to archive Excel data stored that is stored in multiple worksheets for each Excel file. I have tried TransferSpreadsheet but it only imports the first worksheet. Whomever can help I would appreciate your help.
TIA
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro To Import CSV to ACCESS | csvivek | Import/Export Data | 1 | 12-07-2009 10:49 AM |
| Setting default Unicode Compression when import from Excel | AndrewAfresh | Import/Export Data | 0 | 03-16-2009 02:14 AM |
| converting from Access 2003 to Access 2007 | LawrenceLau | Access | 6 | 11-20-2008 12:53 PM |
| Desperately need code to automate Access 2003 from Word 2003 | smdesq13 | Programming | 1 | 09-06-2006 09:48 AM |
| Help! Newbie needs help with Access 2003!!! | infernojericho | Access | 0 | 12-03-2005 05:11 PM |