Export from Excel to Access using ASP in DWMX

[antler44]

Hi
Anyone know an ASP script for transferring data from an Excel sheet to an
Access table, some of the fields of which contain names which have an
apostrophe (') in them.
I have tried all sorts of things but am getting tripped up by the apostrophe
which is used as a field container in the SQL :

"INSERT INTO tblResults Values(0,'" & rsExcel("FeisID") & "' , '" &
rsExcel("CompNo") & "' , '" & rsExcel("Entry") & "' , '" & rsExcel("Name") &
"' , '" & rsExcel("School") & "' , '" & rsExcel("Position") & "' , '0' , '"
& Done & "')"

The first field is the ID field of tblResults and need to be incremented
automatically. If I leave the first value out, I get an error along the
lines of "Number of query values and destination fields are not the same"
Also, if the name field is like Harry O'Hare, the thing fails...
Any ideas anyone? Many thanks

Jim

[artsybrenda]

I recently had the problem with the apostrophe in Excel. What someone told me
to do, and it worked, was to
Copy a blank cell
Select the column of cells with the extra apostrophe
Paste Special, choose Value and Choose Add.

What this does is add a "nothing" to the beginning of the cells which takes
the apostrophe aways.

What happens if you just do a "CSV" export and then import that file into
Access?