B
Bill
Hi All,
I have been given two data files exported from another system, that purport
to be a CSV files but are, I suspect, tab delimited files. The file
extensions are CSV. The files are large i.e. 2GB and contain too many
records for Excel - when trying to open in Excel one gives an error saying
no data, the other truncates the data.
Trying to import into Access its says file is not in a csv format for one of
the files, the other seems ok but has a top row that does not match the rest
of the file and screws the wizard.
I suspect that if I could load the files into something that would allow me
to remove that offending top row, and resave them to another file name in a
conventional CSV format, I could remedy the situation but have not had a lot
of success.
I have tried CSVed and Killink CSV without success - any ideas?
Regards.
Bill.
I have been given two data files exported from another system, that purport
to be a CSV files but are, I suspect, tab delimited files. The file
extensions are CSV. The files are large i.e. 2GB and contain too many
records for Excel - when trying to open in Excel one gives an error saying
no data, the other truncates the data.
Trying to import into Access its says file is not in a csv format for one of
the files, the other seems ok but has a top row that does not match the rest
of the file and screws the wizard.
I suspect that if I could load the files into something that would allow me
to remove that offending top row, and resave them to another file name in a
conventional CSV format, I could remedy the situation but have not had a lot
of success.
I have tried CSVed and Killink CSV without success - any ideas?
Regards.
Bill.