SQl mailmerge.
Hi NG
I have a *.csv mergefile with fieldname: 'Products'
In this field the following words can occur: MP3, MP3_Phone, Phone, CD_MP3
I wish, to mailmerge all records where the word MP3 occur in the
text-string.
I have tried belowed:
Const mergeType01 As String = "MP3"
Const mergeType02 As String = "MP3_Phone"
Const mergeType03 As String = "CD_MP3"
'Do not function: instr
'Products, Products will give all records (test)
Dim strsql As String
strsql = "SELECT * FROM" & MyPath & " \ " & MyFile _
& "WHERE" & (InStr(1, Products, Products, vbTextCompare) 0)"
'Do not function: joker
strsql = "SELECT * FROM" & MyPath & " \ " & MyFile _
& "WHERE(Products = '*" & mergeType01 & "*')"
'This is okay:
'This solution demands programming before new word, and this is
unfortunately not good.
strsql = "SELECT * FROM" & MyPath & " \ " & MyFile _
& "WHERE (Products = '" & mergeType01 & "')" 'continue with: or
I will appreciate any suggestion?
Notice: It is not possible to split the csv-file.
Best regards
Joergen Bondesen
|