PDA

View Full Version : opendatasource - how to stop displaying delimiter query



drpog
08-07-2009, 01:46 AM
I am trying to attach a datasource to the active document. The data source is a csv with delimiters "." and ENTER.
The statement
With ActiveDocument.MailMerge
.OpenDataSource _
Name:="c:\temp\SystmOne RTF\MergeSource.csv", _
Connection:="MergeSource", _
LinkToSource:=True, _
SQLStatement:="SELECT * FROM c:\temp\SystmOne RTF\MergeSource.csv", _
ConfirmConversions:=False
.Fields.Add _
Range:=Selection.Range, _
Name:=Replaces(x)
End With
Always brings up a query box to confirm these delimiters. How do I set these delimiters automatically so that the query box does not appear?