Linking excel and access

[Guest]

Hi

I have a excel spreadsheet with information in that I want to use to fill in
a database record.

How do I do it?

 

[Douglas J. Steele]

It depends on how the spreadsheet is laid out.

If you're lucky, you can simply link to it, or import it. Look under File |
Get External Data.

If not, you may have to use Automation. See, for example,
http://www.mvps.org/access/modules/mdl0006.htm at "The Access Web"