automate copying MS access table to SQL Server 2005 db

[needInfo25]

I have a table in MS Access that I would like to copy/import into SQL Server 2005. I would like to automate this process so that it copies the table over on a daily basis. Can someone tell me how this can be done?

Thank you in advance.

 

[Crowley16]

have a dts package on the server, schedule a job to run the dts once a day...

or set up access as a linked server, and just copy everything across with a proc once a day...

--------------------
Procrastinate Now!