Home |
Search |
Today's Posts |
#1
|
|||
|
|||
why char(96)
Hi
I've word 2002 sp3 win xp pro sp2 and access 2002 sp3 all in french and just installed. I'm doing mailMerge from word in vba When I submit an sql statment to ActiveDocument.MailMerge.OpenDataSource I've to put the name of the table between ` (char 96) (for all the string in the query I can use a single quote) Without this char 96 word pops up an window asking me to choose a table... ActiveDocument.MailMerge.OpenDataSource Name:="C:\myDb.mdb", Connection:="Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Mode=Read;Jet OLEDB:Engine Type=5;Jet OLEDBatab;Data Source=C:\myDb.mdb", SQLStatement:="select * from `myTable` where no = '0003-2001'" |