Using Excel spreadsheet as input to Access
 

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


--
dougb415
------------------------------------------------------------------------
dougb415's Profile: http://www.excelforum.com/member.php...o&userid=27452
View this thread: http://www.excelforum.com/showthread...hreadid=469857