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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.