Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting from Excel
I'm trying to export data from excel to access but I keep getting a syntax
error when I run the export. It seems to error out whenever I have a hyphen in one of my text fields. For example "L.F. O'Leary". It errors out on this because of the hyphen. Everything is set up as text format so why would it error out because of the hyphen? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting from Excel
Correction... It's not a hyphen, it's an apostrophe that is causing the error.
"Secret Squirrel" wrote: I'm trying to export data from excel to access but I keep getting a syntax error when I run the export. It seems to error out whenever I have a hyphen in one of my text fields. For example "L.F. O'Leary". It errors out on this because of the hyphen. Everything is set up as text format so why would it error out because of the hyphen? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Exporting numbers into Excel | Excel Discussion (Misc queries) |