PC Review

Thread Tools Rate Thread

RE: Need automated import of tab delimited sequential files

Posts: n/a
      17th Mar 2010
Did anyone ever give you some ideas? I have the same sort of question--I have
an Excel file that's always placed in the same directory... I'd like to
automatically import it into an Access 2003 database.

Hope to hear back... or at least some good advice on the import issue...

"jjoswalt" wrote:

> I have an SQL dbase which automatically generates tab delimited .txt files
> and places them in the same directory every time. The files are named like
> the following "Orders20090619-053725-125.txt" I have an Access dbase which I
> use to massage order and inventory data, create reports, etc. Currently I
> can import those files manually, but I would prefer to have Access
> automatically bring them in whenever a new file appears or at least upon re-
> opening the database. Is there a way to automate all of this?
> Any assistance would be greatly appreciated!
> .

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

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 On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
space delimited files now tab delimited Sunny Scripter Microsoft Excel Misc 0 31st Mar 2008 12:39 AM
How can I convert tab delimited files to pipe delimited? =?Utf-8?B?SmVyZW15IFRvd24=?= Microsoft Excel Misc 2 15th Nov 2007 05:29 PM
Converting Tab Delimited Text File to A Comma Delimited Text File kwesi.acquah@gmail.com Microsoft Excel Programming 1 13th Jun 2007 03:13 PM
Automated Importing of Tab Delimited Text Files =?Utf-8?B?RG9uYWxkIEouIFNjaGllciAtIGRqc2MgQ29uc3Vs Microsoft Access External Data 2 30th Jan 2006 10:19 PM
Parsing tab-delimited records from a sequential file Bob Howard Microsoft Access Forms 12 27th May 2005 06:35 PM




All times are GMT +1. The time now is 05:40 PM.