Access 2003 Database updating from a tab seperated txt file

[russler01]

I have look all over trying to find information on makeing this happen.

I have a txt file that is "tab" seperated values and I need to have it in a access database. Now this file updates every night around 12am and so I need to have my access database update itself everynight after that. I am looking for the code or help to achieve this.

1. The txt file is on another server and I have ftp access to it. (for additional information it is a MLS for reale state for the county)

2. I need the txt file to auto update the MS Access database. I don't care if it replaces it every day or just updates the changes.

3. I need it to be automatic every night.

I really have no idea where to start this being very new to asp.net and I know nothing about VB. Everything I have learnd so far is from taking code apart and learing it from the insides. If anyone has something like this where I can learn from or if they know where I can learn this from that would be great. I am not asking for anyone to do it for me unless they have that kind of time on their hands. I have been looking for this for 6 months now and still no luck. Any direction would be very helpful!

Thank you much!

Rusty

[Ecniv]

I have some code using API calls in Access. In theory you could be able to use them on Asp. As long as the dlls are regged there too.

It is very complicated though.

Have you looked into scripts and ftp servers? I mean that you may be able to schedule an ftp and transfer the file to the local server (or remote one) and then that server could auto look for ned files about 1 hr after they arrive so it can finish.

I have yet to write a tutorial on how to use them, and am still thinking about it atm.

[zen_master]

kind of related...

is it possible to deploy an app in one computer...and let the database on the server?

it this case, then everybody on the intranet can install their copy of the program and access one database?

thanx =)

[Ecniv]

Intra net.. depends if they can access the server on the list. Probably slow if they are in buildings around the country but possible. Ask your network administrators whether it is feasible.
An alternative (if you have asp) is to put the access (mysql or sql server) be on the intranet server and develop a couple of html forms to send the data to the database. Should be fairly fast and accessable with desktops and a browser (intranet).

As to the linking to a server just with an ip address, not sure this is possible. If you find out and get a working version, post it up as there have been several posts about this. (search the forum - link/button at top)