Excel Spreadsheet and Access Fields

[Bernard Piette]

I have an excel spreadsheet with mortgage rates etc and we are basing some
fields in Access off the calculated fields in excel.

To start we just copy pasted the info into the access table but then client
says he wants to change the data say from 6% to 7% and that be reflectd in
all the fields dependant to said %.

What are my options.

A. I think the best option is to link the specific section of the
spreadsheet into the access table, Ex: UnitFinancials and then if someone
edits the excel mortage document and changes the %'s the information will be
autpopoluated back in the access table and the fields that are linked will
show updated info.

What are my other options?

Thanks in advance

Bernard Piette

 

[[MSFT]]

Hello,

In Access, you can create a link table to an Excel speadsheet. In Access,
you can treat the link table as actual table, but its data is stored in
Excel file.

Luke

 

[TC]

As long as he can tolerate this:

http://support.microsoft.com/kb/904953

http://news.com.com/Patent+ruling+costs+Microsoft+8.9+millio n/2100-1007_3-5735432.html

HTH,
TC

 

[Bernard Piette]

TC thanks for the heads up... good pointers