I realise this is a basic question as I'm not an IT person but it's driving me mad.
I need to import a file of data.
I have saved the file as CSV
I also save the file with columns autofitted and the date column formatted as date
When I try to import using the GM wizard, the wizard will map the field but shows the result as 'bad expression'
When I go back into the CSV sheet the column size has reduced and the date fields are showing as ###########, possibly due to the column size reducing.
I have tried to re-save several time but still keep getting the mapped result as 'bad expression'
It's possibly an easy solution unless you don't now what is!!
Regards
Melanie
I need to import a file of data.
I have saved the file as CSV
I also save the file with columns autofitted and the date column formatted as date
When I try to import using the GM wizard, the wizard will map the field but shows the result as 'bad expression'
When I go back into the CSV sheet the column size has reduced and the date fields are showing as ###########, possibly due to the column size reducing.
I have tried to re-save several time but still keep getting the mapped result as 'bad expression'
It's possibly an easy solution unless you don't now what is!!
Regards
Melanie