I'm trying to import physical inventory data on an excel spreadsheet into my business program. It must be in a quoted comma-delimited format. I haven't a clue how to accomplish this.
Fix1
-----------------------
If you mean in this kind of format
"test", "test1"
Then you would need to add the Quotes to each Excel cell and then do a File>Save As>CSV
Fix2
-----------------------
You can save in a different Format (such as CSV) from Save As. However I'm not sure that Excel has the capacity to add the quotes. Your options therefore are:
1: Manually add quotes to the file; the simplest but most time consuming option.
2: Install and Use Open Office Calc rather than Microsoft Office Excel. OO lets you specify both the delimiter (i.e. comma) and the grouping (i.e. ""). OO has other advantages too, but is definitely overkill if you just want it for this task
3: Use an excel macro to surround all text cells with quotes before saving; probably the most complicated option and least likely to succeed.
4: Run another program against the CSV file to add quotes, essentially doing (1) for you. Probably the quickest and easiest.
Take your pick. If you go for (4) I can get you a simple program.
Fix3
-----------------------------
To ENT:
Thanks so much for the reply.
I would add quotes as a last resort, as the inventory data is in the hundreds!
I have saved the file as a csv file and would appreciate the program to add quotes.
One last thing...the file must be in a txt format in order to import it into this program. Do I just save it as a txt doc after adding the quotes with your program?
Fix1
-----------------------
If you mean in this kind of format
"test", "test1"
Then you would need to add the Quotes to each Excel cell and then do a File>Save As>CSV
Fix2
-----------------------
You can save in a different Format (such as CSV) from Save As. However I'm not sure that Excel has the capacity to add the quotes. Your options therefore are:
1: Manually add quotes to the file; the simplest but most time consuming option.
2: Install and Use Open Office Calc rather than Microsoft Office Excel. OO lets you specify both the delimiter (i.e. comma) and the grouping (i.e. ""). OO has other advantages too, but is definitely overkill if you just want it for this task
3: Use an excel macro to surround all text cells with quotes before saving; probably the most complicated option and least likely to succeed.
4: Run another program against the CSV file to add quotes, essentially doing (1) for you. Probably the quickest and easiest.
Take your pick. If you go for (4) I can get you a simple program.
Fix3
-----------------------------
To ENT:
Thanks so much for the reply.
I would add quotes as a last resort, as the inventory data is in the hundreds!
I have saved the file as a csv file and would appreciate the program to add quotes.
One last thing...the file must be in a txt format in order to import it into this program. Do I just save it as a txt doc after adding the quotes with your program?
Hiç yorum yok:
Yorum Gönder