J
jeff
Hi gurus (sorry for the cross post...wanting to hit the best advice),
I am using some sql statements to pull data from Excel into new Access
tables as per the following example:-
mQry = "SELECT * INTO TempImportDataCL FROM [Excel
8.0;HDR=Yes;DATABASE=C:\Project\CableListData.xls].[CableList$];"
mDb.Execute mQry, dbFailOnError
Which works fine BUT columns which have only numbers in them are being
created as DataType NUMBER whereas in Excel the column is defined as TEXT. I
actually want the Access table Fields to be all TEXT datatype. Can this be
done using the above?
I am planning on changing the resultant NUMBER fields to TEXT fields after
creating the table/data but dont want to hit any snags.
Any help will be appreciated
cheers
Jeff
I am using some sql statements to pull data from Excel into new Access
tables as per the following example:-
mQry = "SELECT * INTO TempImportDataCL FROM [Excel
8.0;HDR=Yes;DATABASE=C:\Project\CableListData.xls].[CableList$];"
mDb.Execute mQry, dbFailOnError
Which works fine BUT columns which have only numbers in them are being
created as DataType NUMBER whereas in Excel the column is defined as TEXT. I
actually want the Access table Fields to be all TEXT datatype. Can this be
done using the above?
I am planning on changing the resultant NUMBER fields to TEXT fields after
creating the table/data but dont want to hit any snags.
Any help will be appreciated
cheers
Jeff