Import parts list spreadsheet to Access

  • Thread starter Thread starter Brian Fielding
  • Start date Start date
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
 
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
 
Back
Top