Hi all...
I have a text file line by line example:
test.txt
aaaaaaaa bbbbbbbb ccccccccc
bbbbbbbb ccccccccc aaaaaaaa
ecc...
I wolud wnat to exoprt the realted value from test.txt in the MDB
TEST.mdb>Table1
filed1 (aaaaaaaa) filed2 (bbbbbbbb) filed3 (ccccccccc)
filed1 (bbbbbbbb ) filed2 (ccccccccc ) filed3 (aaaaaaaa)
Help me please
Hopefully the following addresses what you're describing or something
similar.
You can connect to a csv file (which can be opened in Excel and which an
Excel file can be converted into) in good form just as you can to a
regular database.
The .csv file needs to be uploaded to the server.
And you can have two recordsets open at the same time.
So I'd suggest going through this recordset one row at a time and within
this loop add a new record to the "real" database's recordset.
And for help connecting to a text file using the Jet OLE DB provider:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Pro viders.htm#O
LEDBProviderForMicrosoftJetText
And based on the above link realize that the actual filename does NOT go
in the connection string - rather it goes in the SQL statement
(definitely a little tricky).
Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!