Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2006-12-18 : 11:40:23
|
| Hi people,I'm fairly new to SQL Server and wanted some information using ODBC.On my PC I have an ODBC data source called LIVE_DATA which is situated in System DSN. I want to know how to import data via this ODBC source?I had a look in SQL Server but I wasn't sure which data source to select in the Import Export wizard.I'd really appreciate any help so thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-18 : 11:46:57
|
| ODBC is not a tool. ODBC is a DAL (data access layer) built on API calls.What is the data source made of? Access? dBase? Excel?Peter LarssonHelsingborg, Sweden |
 |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2006-12-18 : 11:49:25
|
| The ODBC driver is supplied but a 3rd party and is used to connect to data which sits on a UNIX machine. Unfortunately thats all I know but its easy for me to import the data into Access from the source. I just can;t see how you would do it in SQLServer. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-18 : 12:03:47
|
| Have you tried right click the database in Enterprise Manager and choose "Import data"?And select "Other ODBC..." as the source?Peter LarssonHelsingborg, Sweden |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2006-12-19 : 09:11:49
|
| I don't see that option. I'm using 2005 so maybe its slightly different. When I select the Data Source the closest I can see is '.NET framework data provider for ODBC'. Is this the correct one I should be using? |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2006-12-19 : 09:39:29
|
| I actually managed to figure out the option I mentioned in my previous post but I ended up getting an error message which said the 'Specified cast is not valid'.I suspect that the driver I'm trying to use isn't compatible with .NET. |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2006-12-20 : 06:02:55
|
| Is it possible to import data into SQL server from an XML file? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-20 : 07:23:23
|
| Read about OPENXML in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Import data via ODBC