Exporting from Excel

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 4
odd non-breaking hyphen behavior 9
Zero's # 2 3
Format Cell and Data Validation 4
dash/hyphen issue 4
import /paste -stop automatic conversion of text 05-12345 to date 1
Numerical Data Appears with - Sign 3
Number stored as text: Frustrated with Excel-Word Merge 2

Top