| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
i want to connect excel with sql server 2000 as database with macr
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Informatica Connect to Excel workbook | Excel Discussion (Misc queries) | |||
| Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) | |||
Threaded Mode
