checking for files and appending text within

ReedBarker
01-12-2004, 03:20 PM
OK this is the deal.

I have a sql database
I have data in raw text (pipe delimited)

I need an automated way to ge the text appended to the current SQL database or into an access database to be appended later.

2nd problem.
these text documents are created daily eachin a new folder corrisponding to the date
folder drill down like this year/month/day/*.txt

How do i get it to check to see if the file has appeared, append it to the database if it has and then move to the next day and stay ther up until it sees the files and appends them?

loquin
01-12-2004, 03:31 PM
does the text file represent a single record in your table? Or, are there multiple records, separated by line feeds, with the fields separated by the pipe?

What have you tried so far?

ReedBarker
01-12-2004, 03:42 PM
does the text file represent a single record in your table? Or, are there multiple records, separated by line feeds, with the fields separated by the pipe?

What have you tried so far?


Here is a sample of the code
Nothing yet. Right now i have to do this all by hand.
I only need some of the data, what i was thnking was sending this all into a access database picking out what i need then sending that into the SQL database. I need as much if not all done automatically.

3186649|COLUMBIA STATE BANK|BEHRENDSEN RANDY B & LYNN||3186649||||||1
3186649||PRINCIPAL RESIDENTIAL MORTGAGE INC||3636238||||||2
3186650|COLUMBIA STATE BANK|BOND DOUGLAS C||3186650||||||1
3186650||PRINCIPAL RESIDENTIAL MORTGAGE INC||3166522||||||2
3186651|COLUMBIA STATE BANK|CITIMORTGAGE INC||3186651||||||1

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum