apostrophe in target Db name throws error

[shymdev]

sql = "SELECT Table1.* INTO Table1 IN '" & sExpFileName & "' FROM Table1"
CustDB.Execute sql

where the sExpFileName contains the path of The Target MS Access DB
The Query works fine. But recently I discovered that if my target File name contains apostrophe It gives error as Query Input must contain at least one table or query

Is there any way to solve this problem. Please suggest me some way

 

[BarryMK]

Not being funny, why don't you change the target name to something simple without punctuation marks?

 

[shymdev]

fair question.. But the target Db can be created by customer.. so he can create file with any punctuation marks . I tried using double apostrophe but that also give me same error

 

[badermsb]

You could get the target db name before you run the query and either remove any apostrophes informing the user of this via a msgbox or you could try and replace the apostrophe with a smart quote (asc 180).

 

[shymdev]

The targetDB is created already in the path speicified in sExpFileName . This query just does the transfer of records from CustDB to target DB . Is there any way to make Access recognize it as a part of file name . I remember using double apostrophe for insertion of data with apostrophe . BUt here that also wont work.

 

[RuralGuy]

Try:
sql = "SELECT Table1.* INTO Table1 IN """ & sExpFileName & """ FROM Table1"
CustDB.Execute sql

 

[shymdev]

Thanks a lot.. My problem is solved..

 

[rsmonkey]

Alternately you can use this:

sExpFileName = db file
sExpFileName = Replace(sExpFileName, "'" "''")

thats how i get around apostrophe's without actually physically chaning them...