Excel Link Design

P

Paul

I am linking to an excel file that will be constantly updated with new data.
How can I define the data type. When I use the link option is quesses at the
wrong data type for a few fields.
 
M

Maurice

If you link, you are linking directly to the source. You cannot set different
datatypes in a direct link i presume...
 
P

Paul

This issue is that Access is determing the datatypes based upon the data it
sees in the cells and it is getting it wrong. This is my issue. Is there a
way to link to an excel file where I set the datatypes?
 
M

Maurice

Paul,

In such cases I opt for the import option. I create an import specification
and use that in combination with some sort of automation. Within the
importspecification you are able to set your own datatypes and with VBA you
can automate the process of importing by using the docmd.transfer option.

hth
 
P

Paul

Thanks for the info. I am not VBA maven, so I am hoping that I can get it to
work with macros. In essence I need to setup a table to meet my spec. I
then need to create a procedure that will erase the existing data and then
import the new data.

Thanks for the help
 
Top