 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / March 2006Ole DB Connections to SQL server
How can i connect other database to Access (2000 and 2003) without using codeOr do i have to write code every time i try it? do i have to installa something? i tried to call a database from Excel and it worked very fine, i even created a .UDL file with no problem. but i cannot make access work that easy. thanks for your help  SignatureData Systems Engineer Bogota Colombia Dear Cesar: It depends on what other databases you have. Do you want to connect to an ODBC source? There's a setup of that. In XP it is Settings/Control Panel/Administrative Tools/Data Sources (ODBC). If not that, then more details, please. Tom Ellison > How can i connect other database to Access (2000 and 2003) without using > codeOr do i have to write code every time i try it? [quoted text clipped - 6 lines] > > thanks for your help Dear tom what i am trying to do is to read a OLE DB source from a GE software called iHistorian, this software allows me to read its data using MSExcel (entering Data MEnu - > import Data - > New Data source .....) is there a similar way in MSAccess to do something like that? Thanks for your help SignatureData Systems Engineer Bogota Colombia > Dear Cesar: > [quoted text clipped - 16 lines] > > > > thanks for your help Dear Cesar: If there is an driver for it, you can set up the Data Source, as I posted before. Or, you could import it to Excel and then from Excel to Access. Or you could try pasting the data. Or you could see if it is already a comma delimited or other recognizable format. Likely if Excel can read it, so can Access, but it may depend on the data, with which I'm not at all familiar. Tom Ellison > Dear tom > [quoted text clipped - 30 lines] >> > >> > thanks for your help Sadly i cannot use that particular solution. i alreayd made a ODBC connection, it is working but we must now use OLE DB. I was using visual basic to make the connection but my boss uses the logic "if it does work in Excel it must work the same in Access" so i must show her it is not the same thanks for your help SignatureData Systems Engineer Bogota Colombia > Dear Cesar: > [quoted text clipped - 40 lines] > >> > > >> > thanks for your help You will probably have to use code. You can import or link tables using the Access UI, without using code, using a JET ISAM driver or an ODBC driver, but not an OLEDB driver. Excel appears to use something called an 'ODC', which apparently stands for 'Office Data Connection'. I searched on 'ODC' at MSDN, and came up with references to Office Web Components and Data Access Pages. These are technologies with which I am not familiar, so I can't say for sure if these references will be useful to you, but for whatever it may be worth, here they are ... http://search.msdn.microsoft.com/search/results.aspx?view=msdn&qu=odc SignatureBrendan Reynolds Access MVP > Sadly i cannot use that particular solution. > [quoted text clipped - 59 lines] >> >> > >> >> > thanks for your help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.