Import a text file as a table in MS Access using VBA

Hi Jimbo,
I see your code to import text files into Access, but please can you put or send me a sample as how to use (Im new in VBA).
This will be very helpfully
Thank you for your help

Dante
pointmicro--at--live.ca

Duration: 
1 month

Comments

1
Jimbo's picture

Hi Dante,

It appears that you're referring to this article wherein I explain how to use VBA to import text directly into a new table.
http://saplsmw.com/Import_a_text_file_as_a_table_in_MS_Access_using_VBA

Any tab-delimited text file with headers will do. I have included a sample below.

Best regards,
Jim

PLNFL	WERKS
0	2001
1	2001
2	2001
3	2001
4	2001
5	2001
6	2001
7	2001
8	2001
0	2001
1	2001
2	2001
3	2001
4	2001
5	2001
0	2001