Using text file as input

[TravisW]

I need to know if there is a way to use a .txt or .doc file as input for a database. Often, clients send me information to update their location or contact information in an MS Word or .txt file. It is usually not typed up in sentence format (think addresses and such). Is there a way to do this through VB, and if so, how would you go about doing it? Any help would be greatly appreciated. Thanks.

[Aaron Young]

If it's Field and Record Delimited, then you should have no problem using it as a DataSource, if using a DataControl, set the "Connect" property to "Text;" and the Database as the File path/Name, if ADO build a Connection string using a Text DSN to do the same thing. once this is doen you can treat the Data as a Recordset/Table:

Note..
Usually the First Record in the file is used as the Field Names, so you may need to insert a Line at the Beginning of the Text document.

Aaron Young
Analyst Programmer
ajyoung@pressenter.com
aarony@redwingsoftware.com
Certified AllExperts Expert: http://www.allexperts.com/displayExpert.asp?Expert=11884