make an import from excel to access to be dynamic

[thread]

Hi all,
i have a problem that seems to be without a result on the surface but
might be found a solution via vba.
i'm trying to import data from excel to access.
there is a problem apon loading a table that doesnt have the same
number of rows as in the access.
the same problem appears when there is a mismatch between labels.
is there a way to bypass this problem in order to make the import to be
more dynamic like for example the option to be able to go by references
in the excel file and not by labels and etc

 

[thread]

do you think i should import just the data or to import all the data as
a table to the access?
the problem will raise inside access or outside as well when there is a
mismatch in the labels
Jeff C ëúá:

 

[thread]

one of the problems that i have is that one of the users in using an
excel template that varies from time to time and its suppose to impact
the database table in the access as well and this is my worse consern
Jeff C ëúá:

 

[Guest]

without detail , cant help.

 

[thread]

the most detail i can give is the issue that the users are chaning name
of culomns in the excel or changing their places
Jeff C ëúá:

 

[thread]

buttom line,there is no magic code for stablize user uploading, its all
a metter how we are overcoming the senarions in the most comterble ways
lmv ëúá:

 

[thread]

Hi all,
i would like to know how much linked tables are more efficient then the
"export" option

thread כתב: