Linking excell with access to choose a single record
 

friends,

I have an Access database (Customers) and an Excel template (Quote
Template). I would like to open the Quote template , click a command button
within the workbook, and bring up a list of record (Customers) from the
database. I would then like to be able to choose a single record from the
list and have the appropriate info imported into the Excel template.

I have searched the board rather extensively and not come across this
scenario. Your help would be most appreciated.

Thanks in advance

Steve

Linking excell with access to choose a single record
 

Can anybody help with this?

Thanks

Steve

"S Willingham" wrote:

friends,

I have an Access database (Customers) and an Excel template (Quote
Template). I would like to open the Quote template , click a command button
within the workbook, and bring up a list of record (Customers) from the
database. I would then like to be able to choose a single record from the
list and have the appropriate info imported into the Excel template.

I have searched the board rather extensively and not come across this
scenario. Your help would be most appreciated.

Thanks in advance

Steve