soulfunkuk
IS-IT--Management
Whenever I try to use the import wizard to upload an excel spreadsheet into access it turns all fields to data type "text".
Even if I have formatted my spreadsheet so the field is data type "number", it turns 10788574823920 to 10788574823+E11.
We have used a select query to repair the number but it simply turns out as 1078857823900 which is incorrect.
Here's the select query:
UPDATE stores SET stores.skus = Format([stores].[sku],"0");
Any ideas?? oh yeah the data type field in the import wizard is greyed out, and you can simply copy and paste over but it would be better if you could import.
Soulfunk
Even if I have formatted my spreadsheet so the field is data type "number", it turns 10788574823920 to 10788574823+E11.
We have used a select query to repair the number but it simply turns out as 1078857823900 which is incorrect.
Here's the select query:
UPDATE stores SET stores.skus = Format([stores].[sku],"0");
Any ideas?? oh yeah the data type field in the import wizard is greyed out, and you can simply copy and paste over but it would be better if you could import.
Soulfunk
