I am importing data from spreadsheet to access database. One of the column in the spreadsheet has data as:
a. Purely numbers
b. Purely alphabets
c. Alphanumeric
The same field in the access is set as "Text" data type.
On importing the spreadsheet, I am getting conversion error for this columns. It has only imported cells with purely numeric characters (point a above).
By...
2 results in 0.0041 seconds.
-
Importing error - Conversion
-
Update query with Dlookup function results in conversion error
Hi Everyone,
I've created a database (MS Access 2003) to help monitor staffing at my work.
I now need to transcribe data from one table (tblPositions) into another (tblTeams) based on a common column (Position ID). Essentially I wish to copy the [Position title] and [Position description] of different positions from tblPositions, into tblTeams according to their already recorded [Position ID] (this is to make the data more...
