daneb
March 13th, 2001, 07:20 PM
Hello.
Is it possible to convert individual tables of an Access .MDB file into corresponding .DBF files through VB code? My program requires that Access tables be converted before sending them thru e-mail to a specified destination. If for instance, I have the following tables (with data already) in my .MDB file:
Table1
Table2
can these be converted into, say, Table1.DBF and Table2.DBF (or any specified filename) which can then be opened and read by a dBase or Clipper databse utility program? If possible, how can the structure or the data type of field names be preserved? How about if the tables have one or more indexes? Can these be converted also into .NTX (Clipper) or .NDX (dBase) files?
Thanks for the info in advance!
Is it possible to convert individual tables of an Access .MDB file into corresponding .DBF files through VB code? My program requires that Access tables be converted before sending them thru e-mail to a specified destination. If for instance, I have the following tables (with data already) in my .MDB file:
Table1
Table2
can these be converted into, say, Table1.DBF and Table2.DBF (or any specified filename) which can then be opened and read by a dBase or Clipper databse utility program? If possible, how can the structure or the data type of field names be preserved? How about if the tables have one or more indexes? Can these be converted also into .NTX (Clipper) or .NDX (dBase) files?
Thanks for the info in advance!