Hi, How do i import data from .xls or .csv to my existing table on sql server ?
Let's say i have 4 Fields in newdata.xls :: name , ph, address, city.
And in my SQL Server Table - i have five fields in customer table :id (int, autonumber),name , ph, address, city
Now need to specify newdata.xls and it imports all existing data from newdata.xls and imports it to SQL server.
So copy all data from newdata.xls and append into customer table.
or if you know from csv then that's ok too, as i conver xls to csv , so if u know how to append from csv that will do tooo.
Any help appreciated.