export worksheet data to access DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a price list that utilizes several dropdown boxes (via data
validation) and vlookup values. when all is said and done, I end up with a
list with a customer name, phone number, and a varied combination of options
in various sections of the worksheet, but definately in nice linear rows. My
desire is to be able to develop some method, whether through VBA or macros to
collect each option, assign it the same customer identifier and bid number
(also to be generated) and export this into an access database.

Hopefully the following example clarifies my ramblings.

customer: Smith
phone: 1234567
date: 28-August

option 1: widget blue $1.29
option 2: widget red $1.29
option 3: hoohah black $4.00
option 4: [empty]

Export Data and append to an Access table.........

custID Date Bid# item color price
1 8/28/06 200 widget blue 1.29
1 8/28/06 200 widget red 1.29
1 8/28/06 200 hoohah black 4.00

Am I dreaming??

Thanks, Brian
 
Why not develop the application in Access to begin with, then use the Access
Tools menu | Office Links | Analyze it with MS Excel option to do what you
need in Excel. That would seem to be easier.
 
I could give it a try.

Peter Ellis said:
Why not develop the application in Access to begin with, then use the Access
Tools menu | Office Links | Analyze it with MS Excel option to do what you
need in Excel. That would seem to be easier.




Brian said:
I have a price list that utilizes several dropdown boxes (via data
validation) and vlookup values. when all is said and done, I end up with a
list with a customer name, phone number, and a varied combination of options
in various sections of the worksheet, but definately in nice linear rows. My
desire is to be able to develop some method, whether through VBA or macros to
collect each option, assign it the same customer identifier and bid number
(also to be generated) and export this into an access database.

Hopefully the following example clarifies my ramblings.

customer: Smith
phone: 1234567
date: 28-August

option 1: widget blue $1.29
option 2: widget red $1.29
option 3: hoohah black $4.00
option 4: [empty]

Export Data and append to an Access table.........

custID Date Bid# item color price
1 8/28/06 200 widget blue 1.29
1 8/28/06 200 widget red 1.29
1 8/28/06 200 hoohah black 4.00

Am I dreaming??

Thanks, Brian
Click to expand...
Click to expand...
 
Back
Top