By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,211 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

importing text files into access

P: 58
hi guys,
i need to automate the process of importing txt files in a folder into the same table in access.i have created a macro todo the job.the following are the probelms that i face:
1. i need to insert values into three new cols for each row getting inserted.one is for inserting the name of the text file and the other two are for current date and time.
2.i need to set the primary key as a combination of four cols( the above three and a PID col that will be present in the text file.)
could any body help me out???
Aug 29 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,616
hi guys,
i need to automate the process of importing txt files in a folder into the same table in access.i have created a macro todo the job.the following are the probelms that i face:
1. i need to insert values into three new cols for each row getting inserted.one is for inserting the name of the text file and the other two are for current date and time.
2.i need to set the primary key as a combination of four cols( the above three and a PID col that will be present in the text file.)
could any body help me out???
Post the logic for the Macro.
Sep 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.