J
JS
Hello,
I have more than 160 txt-files, that I need to import into Access 2000.
Doing this by hand would cause a "hot finger" ;-))
My idea was to use a macro for this task, but I am not very familiar with
VBA and 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.
I have a macro that is doing a similar job, but this macro copies all the
files in one table. So the result is a very large table with all the data in
a row (impossible to identify the original data structure).
Help is highly appreciated
Juergen
I have more than 160 txt-files, that I need to import into Access 2000.
Doing this by hand would cause a "hot finger" ;-))
My idea was to use a macro for this task, but I am not very familiar with
VBA and 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.
I have a macro that is doing a similar job, but this macro copies all the
files in one table. So the result is a very large table with all the data in
a row (impossible to identify the original data structure).
Help is highly appreciated
Juergen