Hi,
I need to import 4 large spreadsheets to a single table, but I'm having trouble with one field. Study Recruit ID should be text because some values are alphanumeric, but when I use the Import Spreadsheet wizard, I can't change this. See attached. It could be because the first 30-40 records ARE numeric, but further down there are definitely some alpha values.
If I go ahead and accept the wizard's settings, then when the data is imported, those records display #NUM!
Help!
I need to import 4 large spreadsheets to a single table, but I'm having trouble with one field. Study Recruit ID should be text because some values are alphanumeric, but when I use the Import Spreadsheet wizard, I can't change this. See attached. It could be because the first 30-40 records ARE numeric, but further down there are definitely some alpha values.
If I go ahead and accept the wizard's settings, then when the data is imported, those records display #NUM!
Help!