You say that the file is exported from Excel. Do you see any strange charaters in a

cell in Excel? Clear the content and try again. If strange characters what is...

Kierian

Thsi is strange. Du you have an example of the file?

Publish the exempel so we can look at it.

/Gosta

Kieran

"I have a CSV file which has been generated from an Excel Spreadsheet."

Why not go around the problem and save the Exel Spreadsheet as a TAB

separated text file and use...

Thank you all for interesting comments in this thread.

We do have different experiences and what works for one

of us may be doesn't work for another of us.

I have been working...

Robert

Why not use bulkinsert to a staging table with one field and then select substring(field,x,y) etc to

get out the individual fields in the textfile.

I started to use SSIS but run...

My advice is to save the Excelfile as a TAB sep textfile and import that file to a staging table

to clean the data (if needed)

/Gosta

Dvora

As happycat describe the issue this is a common problem importing Excel files using DTS.

What you can do is to save the Excelfile as a tab sep textfile and then...

Gerald

Instead of using DTS have you considered using BULK insert in a table tab1 with just one field fieldname type varchar or nvarchar.

When creat a table tab2 with all the...

Pat

I cannot see any way to import the file as it looks in your example without some kind of

"washing". And I don't think you will do that manually each time.

Try...

Pat

I looked at your file. Is it just a one time shot or will you have more files of the same kind to

import?

I will as SteveB says use...

"Gosta,

I agree that automating the client was one of the solutions I had in mind, that's how I started (using SQL / doing BI stuff) as well!

I don't think this...

"First, let me say that this is a well done article. I will join with others in saying that using Ole automation with excel is rarely the best answer,...

"Nice article... I love it when things like this are well laid out and to the point. They key here is not whether some of the "religion" about this...

"whats the coding to put an excel file data into a MS access table?

The table name would be "apciti"

The field names are... PMCO, PMLOC, PMIPMT, PMEPMT, PMEDOC, PMCURI, PYORPM, PYDATE,...

You can do this with a macro VBA code in Excel:)

This is a simplified! code there a user within a company network

or outside if the database is accessible can update...