Someone told me when you if i want to go from text file into a access file i should open the text file like this

but how and where is the schema defined. i looked everywhere in the book and help doesn't really show you. can someone help me please.



Look at opening a txt file search the help file for schema.ini

dim d as database, r as records

a file in c:\temp\customer.txt would be opened like this

set d = opendatabase("c:\temp",true,false,"Text;")
set r = d.openrecordset("customer")