PDA

Click to See Complete Forum and Search --> : Database updating from a tab seperated txt file


russler01
May 30th, 2005, 08:24 PM
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
May 31st, 2005, 06:02 AM
I have VB/VBA Ftp code connection. I haven't used .Net so I do not know how you'd achieve that in .Net.

Perhaps initially you should look at batch/shell commands to ftp down to local, then import?