TransferSpreadSheet actions to do the job.
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of kapil khera
Sent: Thursday, May 11, 2006 5:27 AM
To: [email protected]
Subject: [ms_access] how to import excel workbook file containing multiple
sheets into access
I have a large number of sheet in a single Excel workbook file. I can import
each sheet individually into an Access table using the import wizard of
Access. However the task is very time consuming. I need to automate this
task using
macro so that I can import all the worksheets from my workbook into Access
with a
single command.I know that first we need to Write *VBA code to automate .*
*Plz. help me out*
--
with Regards,
Kapil Khera
[Non-text portions of this message have been removed]
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
