I used DoCmd.TransferSpreadsheet to import a sheet into Access.
But the Acct number column wasn't getting read/transferred into Access.
So I changed the Access table Acct to type Text. Now it's getting read.
Now I want to copy this Acct column (text) to another column in the same table called Account (Long Integer).
In other words I am simply converting the column to another type.
I tried this:
sql = "UPDATE tblPosted Set Account = CInt(Acct)"
And it didn't work (i guess I'll have to turn warnings back on). "Didn't work" means that the Account column remained all null. Also tried Cdbl in addition to CInt. No luck.
A sample acct number is
980508121234
But the Acct number column wasn't getting read/transferred into Access.
So I changed the Access table Acct to type Text. Now it's getting read.
Now I want to copy this Acct column (text) to another column in the same table called Account (Long Integer).
In other words I am simply converting the column to another type.
I tried this:
sql = "UPDATE tblPosted Set Account = CInt(Acct)"
And it didn't work (i guess I'll have to turn warnings back on). "Didn't work" means that the Account column remained all null. Also tried Cdbl in addition to CInt. No luck.
A sample acct number is
980508121234