[MS_AccessPros] RE: RE: Use of apostrophe in data ?

 

Hi Bill,

I am linking an Excel spreadsheet.  Each record in read into a set of local variables to be parsed to two tables in the database.  This is probably not the most efficient method but works.  I had to write a couple of Excel macros to insure the titles in Excel are allowable within Access.  Example Excel column header named "LOCATION" had to be changed to "LOC".

Thanks for the interest.  Any suggestions would be appreciated.

Rod

---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote:

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@...> 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 (8)

Recent Activity:

• New Members 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___