Обсуждение: help importing external excel file

Поиск
Список
Период
Сортировка

help importing external excel file

От
"RPI"
Дата:
I am fairly new to SQL - can anyone give me advice on how to import new data
only from an external excel file.  The data for the excel file will change
approximately a few times per week.

I have been trying to schedule a DTS import but will this check for existing
data - I do not want to import duplicate rows, can I run this someother
way - instead of scheduling to run every day can I have it run only when
changes are made to the file?

I would appreciate any advice on how to accomplish this.

Thanks

joann