Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-18-2009, 02:11 PM
KramerJ KramerJ is offline Windows XP Access 2003 (version 11.0)
Novice
 
Join Date: Mar 2009
Location: Las Vegas, NV
Posts: 15
KramerJ is on a distinguished road
Default Import Excel Worksheets into Access 2003

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


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


All times are GMT -8. The time now is 03:02 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.