>I'm trying to convert a access 2000 database into a vfp dbc. There are tons of tables and I don't want to do it manually because from Access it will only let me create free dbf files so the field names and everything get truncated to 10 characters. I tried using the MDB2DBC program but it keeps crashing on certain tables. Anybody else use any utilites similar to this that works great?
>
>BTW, the mdb2dbc program keeps getting the error when trying to create the vfp table. This is on line 47 of the cmdFinish.Click event. Anybody out there fixed this problem if they have had it?
>
>Randy


Randy - I tend to stay away from Access - but I have a suggestion of something to try ?? I cannot gaurantee that it will work.

1. set up a system dsn to the access 2000 database in your OS ODBC manager.
2. see if sqltables() and sqlcolumns() will work against it from VFP using a sqlconnect() handle.
if so..
a. start a scan..endscan against the output from sqltables.
b. issue sqlcolumns for each table listed in 2.a.
c. take the output from 2b, do another scan..endscan on it, building the string you need to gen the new table inside the vfp dbc.
if it fails - there is good chance you have some vfp reserved word used as a column name in the access table - mark that table as needing manual massaging.
d. create a new remote view back to the access table [using either the scan..endscan technique in 2c or straight view designer with system dsn] and fill it from the access table.
e. copy the data from the remote view into the table.

i know 2.e. sounds redundant - but vfp can massage some data for you if you need, and you can also do some manual massaging as well.

let me know how it works out for you ??

mondo regards [Bill]