D
dougb415
Hello,
I posted this in the New Users forum but only got one answer, so
thought I'd try here as well.
Like so many others, I am an Excel newbie. I was a mainframe COBO
programmer in another life, but that was a few years back
My manager would like me to write an app that will take tracking dat
from an existing Excel spreadsheet (generated by our system) but onl
use a select handful of columns as input to a new Access database tha
I will create.
I'm guessing that I can either a) create a new edited spreadsheet to b
used as input to the Access database or b) use the Import wizard i
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 highlightin
the columns and then doing a "Save As..." but that just gave me an exac
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 manage
will want to run this, but I don't want to have to hand-prep the dat
every time. The one reply mentioned the "Record New Macro" function.
Thanks in advance for any help!
-Dou
I posted this in the New Users forum but only got one answer, so
thought I'd try here as well.
Like so many others, I am an Excel newbie. I was a mainframe COBO
programmer in another life, but that was a few years back
My manager would like me to write an app that will take tracking dat
from an existing Excel spreadsheet (generated by our system) but onl
use a select handful of columns as input to a new Access database tha
I will create.
I'm guessing that I can either a) create a new edited spreadsheet to b
used as input to the Access database or b) use the Import wizard i
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 highlightin
the columns and then doing a "Save As..." but that just gave me an exac
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 manage
will want to run this, but I don't want to have to hand-prep the dat
every time. The one reply mentioned the "Record New Macro" function.
Thanks in advance for any help!
-Dou