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:
OT: Importing Data from Excel to Access
From:
KENT WALLACE <[log in to unmask]>
Reply To:
KENT WALLACE <[log in to unmask]>
Date:
Thu, 8 Apr 2004 08:38:41 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (26 lines) 
DTS in SQL server will do this to almost any machine and format the  data if you have the ODBC.


(Ron)Kent Wallace
Primary Health

>>> Venkataraman Ramakrishnan <[log in to unmask]> 04/08/04 06:15AM >>>
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 *

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

ATOM RSS1 RSS2