B
Bruce
Hi,
I have a funciton that retrieve a html table and saves the data as a .csv
(which is the plan). I have the .csv setup as a link table so I can append my
data (which I wish to keep intact).
The problem is, when I refresh the data, then open the link table the first
field (which is a date type) shows errors. I have discovered that if I open
the .csv and save the file, then open my link table the dates are fine.
1) Why is this happening?
2) How can I avoid/fix it? Worst case, does anyone know how to open and save
a .csv from the current directory in access vba?
Bruce
I have a funciton that retrieve a html table and saves the data as a .csv
(which is the plan). I have the .csv setup as a link table so I can append my
data (which I wish to keep intact).
The problem is, when I refresh the data, then open the link table the first
field (which is a date type) shows errors. I have discovered that if I open
the .csv and save the file, then open my link table the dates are fine.
1) Why is this happening?
2) How can I avoid/fix it? Worst case, does anyone know how to open and save
a .csv from the current directory in access vba?
Bruce