Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send Excel data to Access through button | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions |