txt-files, that I need to import into Access

[ROSE]

Hello all,

I have more than 4500 txt-files, that I need to import into Access
2000.
I NEED UR HELP TO REDUCE MY BURDEN.


My idea was to use a macro for this task, but I am not very familiar
with
macros. Maybe there is already a code that is suitable for this
task.


The macro should do following: After the macro is started, the user
should
be able to select the txt-files that needs to be imported, or at least
the
user should be able to type in the path where the files are stored in.
Then
the macro should import the data into separate tables. The tables
should be
named like the original txt-files. For example if there is a file
123.txt,
there should be then a table in the database with the name 123.


Help is highly appreciated


ROSE


HI Juergen


ITS THE SAME PROBLEM AS U FACED.U MUST HV CUM TO KNOW
and i am sure u must be having solution for this.
i request u to help me as its very urgent to me


waiting 4 ur reply
Rose

 

[Paul_Simon_(Klikwerk)]

TransferText-Method

Try the TransferText-Method, look it up in your help-file. It will work fine.