Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

importing csv file format

Status
Not open for further replies.

kmmloner

Programmer
Dec 10, 2006
12
US
I am being given a csv file with BOM information. When I import it into ACCESS, I specify the delimeter (;) but each line of data is put into the table as one field. How would I get this data into ACCESS correctly?
 
Wouldn't a CSV (comma seperated values) be delimited with a comma?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.
 
Yes, but I am being sent this file with (;), ao I changed the delimiter in the import specs. Are you saying that this is the problem, in other words the csv file import will only work with (,). Thank you for the fast response.
 
Specifying the ; as a delimiter (for the import) should work fine, I'm just not sure how the person sending you the data has created a CSV and used it as the delimiter in that.

Could you post a small sample of the data (cut and paste from notepad) you're trying to import please just so we can have a look at it?

Cheers

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.
 
I will, but it will have to be in the AM as I have left work, I am sorry for delay and I do appreciate the help.
 
Wow, I am sitting here trying to remeber the file and I think it had (") at the beginning and end of each line, that being the case...it would ignore the (,). Man I feel silly if that is the case, I will let you know in the AM. Thanks again for your help.
 
Yeah, that would cause it to ignore the delimiters.

If it does, open it in Excel (assuming that it isn't too many rows to open in Excel) and try editing and then re-saving it using correct CSV delimiters, that should hopefully sort the problem.

I'll check back in the morning and see if we can't sort this out for you.

Cheers

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.
 
That is exactly what it was. Again, I thank you for your time and talent.
 
You're welcome, glad I could be of some help [smile]

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top