Hello,

I posted this in the New Users forum but only got one answer, so I thought I'd try here as well.

Like so many others, I am an Excel newbie. I was a mainframe COBOL programmer in another life, but that was a few years back

My manager would like me to write an app that will take tracking data from an existing Excel spreadsheet (generated by our system) but only use a select handful of columns as input to a new Access database that I will create.

I'm guessing that I can either a) create a new edited spreadsheet to be used as input to the Access database or b) use the Import wizard in Access and just tell it which fields to skip.

If I use the route of creating a new edited spreadsheet:

1) How do I select which columns I want to export? I tried highlighting the columns and then doing a "Save As..." but that just gave me an exact copy of the original spreadsheet, with the columns still highlighted.

2) Is there a way to automate #1? I have no idea how often my manager will want to run this, but I don't want to have to hand-prep the data every time. The one reply mentioned the "Record New Macro" function.

Thanks in advance for any help!

-Doug