Hi All,
I am new to SQL.
I have an excel file that is saved in a location C:\F2008\daily.xls.
How can I automate a process to upload this into a table in SQL.
The SQL database is on a server named SBS2K3, the SQL instance is named HOME database name is DailyReports table name is DATA.
I am new to SQL so if somebody could help with step by step instructions would be great.
Thanks again
Regards
Gerard