G
Guest
i have a table Transcription_temp in sql server2000 i have to import data
from excel daily. My excel file name is today.xls
my excel headings are
Userid Date TID PID Pname Dname Lines Wtype Template Clients
my table header names are
UserID TranscrioptionDate TranscriptionID PatientName
DoctorName LineTranscribed worktype TemplateName
ClientName
i want a macro to connect sql with excel and export the data of excel file
today.xls
to sql server 2000
from excel daily. My excel file name is today.xls
my excel headings are
Userid Date TID PID Pname Dname Lines Wtype Template Clients
my table header names are
UserID TranscrioptionDate TranscriptionID PatientName
DoctorName LineTranscribed worktype TemplateName
ClientName
i want a macro to connect sql with excel and export the data of excel file
today.xls
to sql server 2000