Help me with a database problem

[turbo pete]

Does anybody know how to get MS access to open an excel form from a form? One of my students has asked me how to do it and I don't know. I can get it to open excel but not a specific excel file.

It is bugging me because I can get it to open word and a specific word file but not with excel. Anyone know how to do it.

Cheers Turbo pete

[Leon]

Originally posted by turbo pete
Does anybody know how to get MS access to open an excel form from a form? One of my students has asked me how to do it and I don't know. I can get it to open excel but not a specific excel file.

It is bugging me because I can get it to open word and a specific word file but not with excel. Anyone know how to do it.

Cheers Turbo pete

Can't you drag and drop?

[Actual_Ben_Taylor]

This is taken from "The difinitive guide to Excel VBA' or something...

In executing FILE|SAVE AS you can specify "dBase III" or "dBase IV." Then the current database (the range of cells in which the cell pointer is currently located) of the active worksheet is saved. If a range of cells is selected before the command is executed, then only this range is copied. Excel thus behaves in a manner similar to that for the execution of various DATA commands. The column labels are shortened to ten characters, with any spaces being replaced by the underscore character "_". (Take care that columns have unique labels.) The first data record of the table determines the data format.

The command DATA|CONVERT TO MS ACCESS is provided for such conversion. The command is available only if the ACCESSLINKS ADD-IN has been activated.

Finally, you can also tackle the problem of exporting an Excel table to Access from the opposite direction: To do so, save and close the file in Excel. Then launch Access and execute FILE|GET EXTERNAL DATA|IMPORT. In the file selection form that opens choose your Excel file, which takes you to the import wizard. (Many other database systems are capable of importing Excel tables.)

[turbo pete]

Thanks
Sorted now