import from excel
Better control of datatypes when importing from Excel or linking to a worksheet.
Currently the import decides for you using the first few rows, so often you have truncated memo fields when the first few rows are less than 255 char or errors when the first few rows are numeric but later rows are alpha numeric.
When importing into an existing table the import should honor the datatypes in the table.
Kent Gorrell
shared this idea
3 comments
-
Rob
commented
+2
-
Kent
commented
This is just one of the many suggestions pertaining to Excel/Access connectivity. Probably should merge these all into one suggestion to review linking/importing/exporting to Excel.
-
John Partyka
commented
Also, Excel should stop impulsively converting occasional text field values (that look like digits) into numeric values even though the column was defined as text. We use a 4 char encrypted string identifier for our students which Excel often destroys by converting what appear to be exponential numeric values (eg: the text value "45E7" gets converted into a number automatically by Excel).