Short of writing some nasty code to open the text files directly, no.
What's wrong with issuing several TransferText commands back-to-back?
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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Gary E. Daniels
Sent: Saturday, April 29, 2006 4:16 PM
To: ms_access@yahoogroups.com
Subject: [ms_access] Batch Import Question
Hi. I'm using Access 97 (still). I'd like to know if there is a way to
"batch" import files. I have numerous text files. All are identically
structured and delimited. Each text file contains data for 1 record of an
Access table. I can import these one-by-one, but wonder if there is a way
to import them all at once. Or, somehow combine all the data into one text
file, then import that file. Thanks.
Gary
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.
