G
George
I have successfully imported a table from Excel into Access with the
TransferSpreadsheet method. However, there are two fields whose data types I
want to change. One is a number (double) that I want to change to a number
(integer) and the second is a number (double) that I want to change to a
currency.
What is the VBA code to change a data type?
For example:
dim db as database
dim rst as recordset
rst = db.OpenRecordset("Table")
rst("ID").DataType = Integer
rst("Salary").DataType = Currency
rst.Update
rst.Close
Thanks.
TransferSpreadsheet method. However, there are two fields whose data types I
want to change. One is a number (double) that I want to change to a number
(integer) and the second is a number (double) that I want to change to a
currency.
What is the VBA code to change a data type?
For example:
dim db as database
dim rst as recordset
rst = db.OpenRecordset("Table")
rst("ID").DataType = Integer
rst("Salary").DataType = Currency
rst.Update
rst.Close
Thanks.