Importing Excel Table with invalid Field names

[rehanemis]

Hy,

I would like to import excel sheet that contains about 45 fields and the fields names are not well defined(not obey the Access rules). I would like to import the sheet into ms access without changing the excel sheet because i have to provide only the interface to users where they have to import sheets only. (All the time In Excel fields name are arranged and in specific order but invalid names of fields).

After 1 week the person has new excel sheet with same format and the process of importing data into ms access will be continue for whole year or more.

Please give me suggestions so that i can develop method in that way you suggest.

Thanks and waiting of your answer.

 

[CJ_London]

1. link to excel file rather than import (exclude headers if necessary) then
2. run an append query or whatever to update your db

 

[rehanemis]

1. I can't link the excel file because after each month they got new file with some other name.
2. i have established interface for import into a table .

in this situation what i have to do

 

[rehanemis]

How can i make link. Can i develop a button to link a new one file?

And if linked that what about the invalid fields name?

 

[CJ_London]

if you want a code/macro solution - google 'transferspreadsheet'