Linked Table!

[watzmann]

Hi All ,



I have developed a database which should be filled up everyday by me then i thought i may generate everyday excel sheet contains the same data i need to insert in my database .

my question is , how can i link the excel file only one time and Acess get the data and store it based on the daily date .

i mean , i need Access to get the updated data on a daily base and store it in the database table under the same update .

hope that is clear , thanks for your support

[NoellaG]

Hi,

if you have to import new data out of excel sheets every day you can:
-create an import button with the button "cmdImport"
-on clicking the button code can show up a pop up browser so the user can browse for the file that needs to be imported.
- then import the file into a temp table
- then launch a series of action queries that puts the new data in the right tables
- then delete the temp table
- then show a msgbox like " xxx records updated/imported."

grNG