replace text in CSV file through VBS to import into access
Posted on 2006-11-12
I have written a VBS file to Find " in my csv file. I need to get rid of all the " as I don't need them and it's hurting the quotes being used as a text qualifier when importing the file into access as a table (unparseable record) I think i'm missing something in the code because I keep getting an error.
First here is the code
Set myXL = CreateObject("excel.application")
myXL.workbooks.Open "g:\Subgroup\Access Data\lbx\RAW DATA\oSPEC\tbl_atl_ospec.csv"
myxl.displayalerts = false
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
myxl.displayalerts = true
Set myXL = Nothing
The error is "expected Statment"
Source: Microsoft VBScript Compiliation Error
It specifically references this line and "what:=""",
Can someone look over my code in its entirety and help me make sure that I'm doing this right
I am trying to remove all " in the file.