Import a Excel form in Access

[hartwell]

Is this possible at all?

 

[THWatson]

hartwell
I assume you mean an "Excel" sheet, not form.

Sure, it's possible. Take a look at Get External Data, and then Import, in Access, and an option is to import an Excel work sheet.

Tom

 

[hartwell]

No i mean a Excel Form made in VB

 

[THWatson]

hartwell
Ah, I should not have assumed.

To be honest, I have not worked with forms in Excel so don't know whether or not you can import the Excel form to Access. I do see, in Excel Help, there is a way to transfer data from an Excel form to a database.

Tom

 

[CautionMP]

hartwell,
In a word, no. Unlike the other office products Access does not use the UserForm object, and if you do any import/export actions on a form in Access you get the underlying data and not the form object it's self.

Is your UserForm in Excel so ugly complicated that you can't recreate in Access?

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)