Im trying to import an excel file with vba can any one give a code example

[Michael Kerr]

Im trying to import an excel file with vba can any one
give a code example, or point me to a ORGANIZED METHOD OF
Searching MS Site?


M~

 

[Douglas J. Steele]

You want to use the TransferSpreadsheet method in Access.

Try going to http://search.microsoft.com/advanced_search.asp?siteid=us/dev
and doing a search using "import excel access vba" (without the quotes) in
the "All of these words:" box.