Import Excel Fields into access

[tj63069]

Is there a way to import cells from Excel into an Access Table. Example,,, I would like to import Cells c4, d8, t16 etc..
I have inherited a spreadsheet that evolved into a "form" for the sales group to submit via the internet. As you can imagin over the past 5 years we now have thousands of spreadsheets and the data has to be retrieved for the new CEO :-(

 

[humbleprogrammer]

You can link to the Excel spreadsheet and then create an append query from your linked Excel into your table.

Link Excel by
- opening database in design view and go to the tables object.
- Click New - Link table.
- Choose Your Excel Doc.

Create Append Query
- Create a new query using design view.
- Choose your linked Excel from the table list.
- Click query on the toolbar and change it to an Append query.
- Choose the table name you want to append it to.
- Select the fields you want to append from your excel.
- Set the appropriate Append To: dropdowns to the fields in your table.

Hope this helps.

 

[mikey69]

Try Creating an extra worksheet in Excel, with formulae to add the ceels you want and then using the link or import facilities in Access to get the data from that new worksheet

Access makes all things possible. It even makes them intelligible

 

[tj63069]

Thanks for the suggestions. I couldn't accomplish "Humbles" because the fields are scattered about the spreadsheet just like a form. Mikey's suggestion works and that was the only solution I could find before my request for help. I guess I was hoping there was some picking solution that didn't require the A1,B1,C1 criteria. Incredible how people use spreadsheets to do database work????????

 

[mikey69]

Not really surprising - the ground rules for relational databases are not often taught to non-addicts, in my experience and they're certainly not intuitive.

Access makes all things possible. It even makes them intelligible