Import parts list spreadsheet to Access

B

Brian Fielding

I need to Import data from an Excel Spreadsheet to Access (both 2007) - I
can do this longhand but there are several large spreadsheets and this needs
to be done on a regular bases. Can you please suggest a more user friendly
way and/or automated way of doing this (vba or whatever if necessary).



Is there any software available to do this ?





Excel worksheet:

Parts list with columns for type of machines and x indicating that part is
used in machine:





Part Description ABC ABD ACX etc



A1 Part A1 x x

A2 Part A2 x x

..

..

Z3 Part Z3 x x





Access Data Base:



Create Machine-Part table with column 1 machine and column 2 as part

Table would be



Machine Part

ABC A2

ABC Z3

ABD A1

ACX A1

ACX A2

ACX Z3



etc



Thanks

Brian
 
J

Jeanette Cunningham

Brian,
4Tops.com has software that does this.
I haven't used this software and I have no connection with this company.
I haven't heard any recommendations for or against it, but it may be worth a
try.


Jeanette Cunningham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top