Ole DB Connections to SQL server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
--
Data Systems Engineer
Bogota
Colombia


Tom Ellison said:
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
Click to expand...
 
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


Cesar_duque said:
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
Click to expand...
 
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
 
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
 
Back
Top