H
hyniem
Guest
Hi,
I am writing a VBA code to load data from a text file to Access. I ran into 2 problems:
1.Apostrophe problem:
sample field: http://www.bus.ualberta.ca/rfield/Chip'sChallegne/chip.htm
Once access see the apos'trophe, it gives me an error and refuse to load (error 3076?)
2.Another field with different length and lots of exception:
sample:
-Mizilla/4.5+[en]+(Win95;+l)
-Mozilla/4.0+(compatible;+MSIE+5.0;+Windows+98;+DigEt)
-Xenus's+Link+Sleuth+1.0p
-Mozilla/4.0+(compatiblel+MSIE+4.01l+Windows+95)
-chip
(the hyphen in front just for indication of each line)
In that, how can I just get only Mozilla/4.*,
and the OS like Windows9*.
Thank you very much
I am writing a VBA code to load data from a text file to Access. I ran into 2 problems:
1.Apostrophe problem:
sample field: http://www.bus.ualberta.ca/rfield/Chip'sChallegne/chip.htm
Once access see the apos'trophe, it gives me an error and refuse to load (error 3076?)
2.Another field with different length and lots of exception:
sample:
-Mizilla/4.5+[en]+(Win95;+l)
-Mozilla/4.0+(compatible;+MSIE+5.0;+Windows+98;+DigEt)
-Xenus's+Link+Sleuth+1.0p
-Mozilla/4.0+(compatiblel+MSIE+4.01l+Windows+95)
-chip
(the hyphen in front just for indication of each line)
In that, how can I just get only Mozilla/4.*,
and the OS like Windows9*.
Thank you very much