| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extra/empty records in CSV file
I have an Excel file that I convert into a CSV file. The information in this
file is usually no more than 400 records. If I view the CSV file in Notepad, sometimes the file contains 65,000+ records, which has my 400 records and empty lines that contain commas only. But sometimes it only contains my 400 records. I need to figure out how to eliminate the extra records because I have to import this into my payroll software. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing file with fixed width, multi-line records | Excel Discussion (Misc queries) | |||
| Excel file automatically opens | Excel Discussion (Misc queries) | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
| save an excel file in fixed length records whose fields are blank | Excel Discussion (Misc queries) | |||
| cannot open excel file, please help!!! | Excel Discussion (Misc queries) | |||
Threaded Mode
