Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Unhappy Unanswered: SELECT INTO Not keeping Data Types

    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!


  2. #2
    Join Date
    Feb 2002
    What happens when you insert values other than numeric - what is the datatype ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts