Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems importing CSV file

Status
Not open for further replies.

sgp2004

Technical User
Jun 9, 2017
1
GB
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top