Linking to Excel files with Access 2000

[rarich01]

Just wanted to know, has anybody ever had any problems linking to an Excel file through Access 2000? The reason I ask is that I can't seem to get that to work. I run through all the steps of linking, however, once I hit ok in the dialogue box, nothing happens. No error, no nothing. I can link to other types of files, but just not Excel. I'm wondering if this is a local problem or not. I tried doing the same thing on my laptop, however, still nothing. If you have any ideas, please let me know.

Thanx

 

[scking]

When you use the file\external\link and the common dialog box pops up is there a filter for the Excel file groups? I've done this hundreds of times with no real problems. I even use code to pop up the wizard.

RunCommand (acCmdLinkTables)

Let us know a little more detail.

Steve King Growth follows a healthy professional curiosity