correct syntax

  • Thread starter Thread starter mtress
  • Start date Start date
M

mtress

I'm kind of new at this-I'm trying to link an excel file
directly into a query. This is my first programming
attempt. Two things-when I run it I get a message:
 
I'm kind of new at this-I'm trying to link an excel file
directly into a query. This is my first programming
attempt. Two things-when I run it I get a message:
Click to expand...

eh? Looks like you hit Ctrl-enter prematurely (as I have been known to
do myself...)

No programming is required.

You can use File... Get External Data... Link; select the appropriate
version of Excel from "files of type"; and link to the spreadsheet.
You will be able to assign this linked "table" a name; that name can
then be used in creating a Query, just as if it were a native Access
table.

If you are using VBA code to create the link, check out the
"TransferSpreadsheet" method in the VBA online help.

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top