Selasa, 19 November 2013

[MS_AccessPros] RE: Use of apostrophe in data ?

 

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

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar