| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
importing csv
I periodically import .cvs files that contain data like
0000 00 00000 0 at various places in the file. I need to capture the correct characters in Excel. Because Excel insists on dropping leading zeros, I am forced to rename the file as .txt before opening it. I can then tell the import wizard to treat the data as text. Is there a better way? -- Gary's Student |
|
#2
|
|||
|
|||
|
importing csv
This seems like the easiest way to me.
Well, if the files that you import all have the same layout, you could record a macro that imports the data. The macro would still specify the fields the way you like them. You could even add headers/footers/print settings/filters/etc to your macro. Then just run that macro when you need to import that data. (Yes, you'd still have to rename the file to .txt, though.) Gary''s Student wrote: I periodically import .cvs files that contain data like 0000 00 00000 0 at various places in the file. I need to capture the correct characters in Excel. Because Excel insists on dropping leading zeros, I am forced to rename the file as .txt before opening it. I can then tell the import wizard to treat the data as text. Is there a better way? -- Gary's Student -- Dave Peterson |
|
#3
|
|||
|
|||
|
importing csv
Thank you
-- Gary's Student "Dave Peterson" wrote: This seems like the easiest way to me. Well, if the files that you import all have the same layout, you could record a macro that imports the data. The macro would still specify the fields the way you like them. You could even add headers/footers/print settings/filters/etc to your macro. Then just run that macro when you need to import that data. (Yes, you'd still have to rename the file to .txt, though.) Gary''s Student wrote: I periodically import .cvs files that contain data like 0000 00 00000 0 at various places in the file. I need to capture the correct characters in Excel. Because Excel insists on dropping leading zeros, I am forced to rename the file as .txt before opening it. I can then tell the import wizard to treat the data as text. Is there a better way? -- Gary's Student -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IMPORTING WORD DOCUMENT INTO EXCEL | Excel Discussion (Misc queries) | |||
| number of fields exceeds 256 when importing from a dbf file | Excel Discussion (Misc queries) | |||
| Importing data into excel | Excel Worksheet Functions | |||
| Importing text file | Excel Discussion (Misc queries) | |||
| How to import a path/filename when importing data into an XML list | Excel Worksheet Functions | |||
Linear Mode
