How are you importing the data?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In ms_access_professionals@yahoogroups.com, <desertscroller@cox.net> wrote:
Hi All, I am importing data from an EXCEL spreadsheet (an apostrophe may be imbedded in the string from EXCEL). When I then try writing the data to the appropriate table in ACCESS, I get an error message 3075 Syntax error (missing operator) in query expression.
Is there any easy way to allow the data to be imported as is? I can write a macro in EXCEL to run that would remove all apostrophes if needed but would prefer to maintain the data as is.
Using Office 2010 products.
Example of the data - JD'S HANDYMAN SERVICES
Thanks for any suggestions.
Rod
Is there any easy way to allow the data to be imported as is? I can write a macro in EXCEL to run that would remove all apostrophes if needed but would prefer to maintain the data as is.
Using Office 2010 products.
Example of the data - JD'S HANDYMAN SERVICES
Thanks for any suggestions.
Rod
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar