I have an MDB, in which I'm running a VB script (OnClick) that will import data from a csv.
But I've noticed, when I successfully import the data, my autonumber ID field has the number 3775 appended to the beginning of it.
Note: I'm not importing every field from the csv, just a few.
This is some rough code.
'Transfers data into temporary table in Access
DoCmd.TransferText transfertype:=acImportDelim, _
FileName:="D:\Documents\Examples\Monthly Data.csv", _
'Inserts data from temp table into "live" table
Currentdb.Execute "INSERT INTO MyLiveTable(Col1, Col2, Col3) SELECT Col1, Col2, Col3 FROM MyTemporaryTable"
The autonumber field has changed like this....
2065, 2068, 37752069, 37752070, 37752071...
How do I get rid of this?