I am using a SELECT INTO statement ("select * into TEMPSLS from SLS0802.dbf") to backup a database, but the problem is that it does not seem to keep the data types. All the small ints are changed to float. This ends up being a big problem. The code i use to connect is:

dbDBF.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=" & Directory
where Directory is the directory holding the dbase databases.

Please help!

Noah

What happens when you insert values other than numeric - what is the datatype ?