What about making a web query from Excel directly ?

NickHK

"Arvi Laanemets" wrote in message
...
OK. I decided for saving CSV-file manually to *.xls. So currently steps to
get payment table into Access a
1. User saves the data from web page as CSV-file.
2. User opens CSV-file with Excel, and saves as Excel workbook - all
columns
are split properly.
3. User opens special Excel file, and starts a procedure, which generates
a
new lease payments table. The Excel file is saved and closed
automatically.
4. In Access project, when any changed data appear in linked Excel table,
user can start a procedure for refreshing lease payments table.

An additional step compared to original plan (no. 2), but an easy one. And
as bonus, user can replace CSV-file name, which is a random sequence of
numbers, with a more meaningfull one.


Arvi Laanemets