Importing/Export Data?

[schweitzerc]

Hi guys,

I need some help here. We have a new computer system at work that can import a lot of data that we normally keyed into the system.

The issue I have is that my data is in an Excel spreadsheet and the import has to be in a text file. I've attached an example of the text file the system is looking for with a description of what the numbers mean. The odd thing to me is that all of the entries are enclosed in quotes and not just separated by commas.

I am running Excel 2010. Is there a way to export my data in this format? The other issue is that my spreadsheet contains more information than I want to import. The information on the spreadsheet that I want to export is Column B (SKU), Column A (Page #), Column I (Space). Each row on the spreadsheet would have to be a different row in he text file.

Any help would be appreciated!

[schweitzerc]

No one knows the answer to this?

[ryanmorris]

First thing I would do is copy just the three columns you have to a blank sheet in the order you need them in the text file (SKU, Page # and Space).

After that you can use concatenate to combine them into one cell. You can then copy that one row of cells to a blank workbook with one sheet and save as a text file. I'm trying to figure out exactly how to do it at the moment and get the quotes and commas in there that you need. There is probably a much simpler way of doing this than what I just came up with but if it works it works. I'll let you know once I figure it out.

[ryanmorris]

So far what I did was this:

Step 1 - Copy the three columns you need (in the correct order in which you need them) to a blank worksheet in columns a, b and c

Step 2 - Place a double-quotation mark in a blank cell and a comma in a blank cell

Step 3 - In the fourth column, use concatenation to add a quote, then first entry, quote, comma, quote, second entry, quote, comma, quote, third entry, quote

Step 4 - Copy all of this information to a blank text file and save it.