Last post Feb 24, 2011 06:44 AM by stanly
Feb 24, 2011 06:29 AM|hari.bristol|LINK
I have excel sheet and I have 5 columns all are of type VARCHAR's.
I have a Table called Details and has 5 columns all of type VARCHAR's.
I have to import the data from Excel to table every day.
I am manually copying the records from excel to and pasting them into the sql table. This approach is easy and quick.
But I want to make it automated.
Can I do it through the coding by giving the location of Excel Sheet.
I am using SQL 2005 and Excel 2007.
Any suggestions or directions please.
Feb 24, 2011 06:44 AM|stanly|LINK
Hope this helps...