-
Jun 18, 2006, 09:26 AM
#1
Table to access
Hi , guys! does anyone know of a way/component to get a mssql2000 table into ms access file. ?
i have a tadoconnection to a mssql2000 table. i want to export it to xls or mdb. i know this can be done if i was uing the jetdriver 4.0.
Last edited by Artificial_Intelligence; Jun 18, 2006 at 10:51 AM.
-
Jun 26, 2006, 02:15 PM
#2
Then use the JET Driver to access the MS Access DB file and troll the SQL2000 table while inserting the field values in MS Acess for every row in the SQL2000 table.
A while not Table.eof do loop will suffice.
-
Jun 26, 2006, 02:54 PM
#3
Well I neglected to mention that that the sql table is a dynamically generated one. Meaning the fields will not be the same all the time. However, I see what you are saying, it might mean I have to create an empty access table open it then insert the data. Maybe emptying it after they copy it to a new location. (I need a good book on ole/automation in Delphi)
Thinking out loud there,,,,,,,,,,,,,,,,,thanks much.
Rasspect
-
Have you tried these components? They may do the trick.
Component name File format
TSMExportToXLS MS Excel directly without OLE
TSMExportToExcel using MS Excel as OLE-server
TSMExportToAccess use the DAO/MS Jet
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules