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

Help needed with table field names

P: 84
I have several large text files that are comma delimited and I want to move the data into my access db. The problem I have is that the text files do not have column headers. When I import the file I do not want to type in each column header manually. The text files I am dealing with have 60 plus columns. I have a doc that lists each of the column names. Is there a way to paste this into the table field location?
May 16 '07 #1
Share this Question
Share on Google+
1 Reply


P: 84
Oops. I think I found my solution. I created a text doc with all column headers separated with a comma. I imported that text file into my DB. I then imported the text doc without the headers into the one with the headers. Not a pretty way but it worked.
May 16 '07 #2

Post your reply

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