HP3000-L Archives

April 2004, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Importing Data from Excel to Access
From:
Venkataraman Ramakrishnan <[log in to unmask]>
Reply To:
Venkataraman Ramakrishnan <[log in to unmask]>
Date:
Thu, 8 Apr 2004 17:45:14 +0530
Content-Type:
text/plain
Parts/Attachments:
text/plain (16 lines) 
Hello Everybody,

This is quite off track but still I thought I will give it a shot....
I have quite a few excel workbooks each containing many sheets; I would
like to export all the data into one single table in an MS-Access
Database.
I can do this manually but is there any vbscript/tool that can be used
to automate this entire process??
All the excel workbooks are present in a single directory.

Regards,
Venkat 

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2