Unstructured Data Doesn't Import; replaces w N/A
Posted: Thu Dec 08, 2011 10:06 am
I'm using Evies 7.1
I'm trying to import unstructured data from excel. I go to File, open, foreign data as work file. I select my excel file.
Everything looks good so far., I go to Step 1 and select the sheet. How cool, I see my data!
I go to step 2, and I toggle through, making sure everything is good. Data types look right. I see my data. Still goo.
I click next. Now in Step 3, suddenly all my data is coming through as N/A! What gives? I've tried doing an actual import. I've tried .dbf, .txt, .csv. Nothing. I always get the same error.
What's the problem here?
I'm trying to import unstructured data from excel. I go to File, open, foreign data as work file. I select my excel file.
Everything looks good so far., I go to Step 1 and select the sheet. How cool, I see my data!
I go to step 2, and I toggle through, making sure everything is good. Data types look right. I see my data. Still goo.
I click next. Now in Step 3, suddenly all my data is coming through as N/A! What gives? I've tried doing an actual import. I've tried .dbf, .txt, .csv. Nothing. I always get the same error.
What's the problem here?