Query Headings

[allan320]

I created a csv to allow me to update sage act witht he contents. The problem is that the csv file adds the Field Headings which is causing act to fail to recognise any of the data to import.

When i created a blank csv file without these headings, the data was recognised and available for import. My question is... how do i get rid of these headings?

Thanks

Allan

 

[neileg]

When you use the export wizard it gives you the option to include field names as the first row. Just make sure this option is unticked.

 

[allan320]

Thanks, i found that option. But when i use the query for import, it appears with a string full of funny looking characters, and none of the data in the csv.

 

[neileg]

Sorry, I don't understand the reference to import. Is this in ACT? You can open the csv with Notepad and see exactly what it contains and this should help you identify where the problem lies.

 

[allan320]

when i open the file, it contains the correct data. when i try to import it from the file menu it gives this screen

but this is not in the csv file at all ?