Access to Excel

[Guest]

Hello all...
i would like to design an access form. allowing me to put in some
information & then sending it to Excel & putting it into the correct cell ?
is this possible. any help would be much appreciated.

 

[Guest]

You can link your Excel into Access.
On the menu click on FILE - Get External Date - Link Tables.
At the bottom of the pop-up window select Excel as type of file. Locate
your file and select the correct sheet.

 

[John Nurick]

Hi Matt,

Here's sample code for putting data into a cell in an Excel worksheet:
http://www.mvps.org/access/modules/mdl0006.htm

Or you can do it by running a query like this, which puts 55 in cell B4
of Sheet1:

UPDATE
[Excel 8.0;HDR=NO;Database=C:\MyWorkbook.xls;].[Sheet1$B4:B4]
SET
F1=55
;