How to Import External Excel Data into a customized Data Entry Form

[matrix7410]

Hello,
I've spent lots of time creating a user friendly data entry form in
acess with lots of dorp down options and mask. But, now I just found
out that we will be getting some esternal excel data which will be
needed to brought into the form. The data that are entered in the
data entry form gets saved into a master table so I'm guessing that
the external data would have to be added to the master grid without
having to go thourgh the data cleaning process in the form. How would
I be able to add these external excel data to my Master Grid? thanks!

 

[golfinray]

I link excel data directly to a table. I put the excel files on the network
drive and use the linked table manager to link up. The I use update queries
if I need any of the data to go into a table. For a form, I have found that I
can directly link a form to the linked excel data UNLESS I need different
datatypes. Try to set the datatypes in excel (for example, text, number,
currency) BEFORE you link it.