append data from excel table to sql table

[Sorin]

i have a database on sql server 2008 with one table. The data in that table comes form an excel file.
how do i append the data in the excel to the existing sql table?

how can i make the process automatic without having to use the import wizard every time?

i'm guessing that an insert into...from.. query would do the trick but i don't know how to provide the excel file path.

[ck9663]

Here, read this

Good Luck!!!

~~ CK