Aug 8 2005, 07:33 AM
Hi, I have an excel csv file with over 80,0000 lines of data, comma delimited, too big to open in excel. It has a header containing 6 lines. having trouble importing into access. (it doesn't like the header) Was told to open the file in Notepad, delete the header and then import to access. Is this correct? I'm a mere simpleton please explain slowly....
Aug 8 2005, 11:19 PM
First a CSV is NOT an Excel file. Excel can read CSVs but a CSV is just a plain text file with records laid out in rows with fields separasted by commas.
For Access to import the file, the whole file needs to be laid out that way. If the file has header info prior to the the first record or row of header labels, then that info needs to be removed first. Make a copy of the CSV, open in Notepad or any other text editor and remove those extra lines.