import excel (tab delim) files?

[robert]

Does access 2000 have a macro that can import and overwrite an existing
table in the database everytime you open the database? The file would
be a tab delim/excel file that will either be on my desktop, or if it
can download it from a website that would be awesome, but I have no
idea if it can be done or how.

Thanks,
Robert

 

[Steve Schapel]

Robert,

You could use a macro, or you could use a VBA procedure, to:
- delete all records from the existing table
- import the data from the Excel file
- append the data from the imported file into the existing table

Downloading from the web server, however, would be very difficult with a
macro. There are, however, ways this can be done with VBA. For
example, you can install and reference an ActiveX control such as
ChilkatFTP, which provides methods to transmit files via FTP, and
exposes these methods to VBA.

So, in a nutshell: Yes, it is possible. The details might take a bit of
working through. For a start, I am not sure about "tab delim/excel".
In my experience, it's one or the other, not both?