Hi, apologies in advance if this quesiton was previouly raised, but I couldn't find the answer anywhere.
Does anyone know if there is a way to turn off or idealy set auto data type identification to "Short Text"? I believe MS Access looks at the first 24 rows and applies data type for the table. In my case first 24 (in fact 1000s ) of first column data might be a Number but I need to be Short Text as some of the numbers are alphanumeric.
So I'm importing data first to a temp table then passing data to another table via ODBC connection. So is there a way to make sure that in temp table "tblrsSLPARENTTEMP" data type will always be set as "Short Text"?
Set db = CurrentDb
On Error Resume Next: db.TableDefs.Delete "tblrsSLPARENTTEMP": On Error GoTo 0
db.TableDefs.Refresh
DoCmd.TransferText TransferType:=acLinkDelim, TableName:="tblrsSLPARENTTEMP", _
FileName:=strPathFile, HasFieldNames:=True
db.TableDefs.Refresh