importing csv file format

[kmmloner]

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?

 

[HarleyQuinn]

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.

 

[kmmloner]

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.

 

[HarleyQuinn]

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.

 

[kmmloner]

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.

 

[kmmloner]

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.

 

[HarleyQuinn]

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.

 

[kmmloner]

That is exactly what it was. Again, I thank you for your time and talent.

 

[HarleyQuinn]

You're welcome, glad I could be of some help

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.