Import a text file as a table in MS Access using VBA
Submitted by Anonymous (not verified) on Fri, 01/03/2014 - 10:21
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
Importing to VBA from text file sample
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