Import from filemaker pro to SQL Server 2005

We are trying to automate an import data from a table in a filemaker pro
database to a table in a SQL Server 2005 Database. Is this possible using
SQL Server 2005? If so, what are the steps I need to take?
To transafer data from any other source first you have to create a ODBC
connection.
Start->Settings->Control Panel-> Administrative Services->Data Source (ODBC)
and check if there is a ODBC Driver for filemaker database extension. I am
not sure if they would have this required driver. When you click on the Add,
'Create New ODBC Driver' window will pop up. Look in the name section to see
if your database extension is there. If so, you can add that, and your
database name and create an ODBC connection, so you can use a DTS package to
automate data import.
Thank you
Sam
"newie" wrote:

> We are trying to automate an import data from a table in a filemaker pro
> database to a table in a SQL Server 2005 Database. Is this possible using
> SQL Server 2005? If so, what are the steps I need to take?
|||We have the filemaker pro driver. However, it doesn't allow me to add the
database name as you indicated. The DSN connection was created as a remote
connection using the server address. I am able to import the data using
excel without any problems using the FileMaker Pro DSN connection. I tried
adding the filemaker pro as a server link but that didn't work either. Any
other ideas?
"bluefish" wrote:
[vbcol=seagreen]
> To transafer data from any other source first you have to create a ODBC
> connection.
> Start->Settings->Control Panel-> Administrative Services->Data Source (ODBC)
> and check if there is a ODBC Driver for filemaker database extension. I am
> not sure if they would have this required driver. When you click on the Add,
> 'Create New ODBC Driver' window will pop up. Look in the name section to see
> if your database extension is there. If so, you can add that, and your
> database name and create an ODBC connection, so you can use a DTS package to
> automate data import.
>
> Thank you
> Sam
>
> "newie" wrote:
|||Hi, If you have the drive, does that show up in the list if you try to DTS?
you can right click on SQL Server database->All Tasks->Import data->
will get you to Data Import Wizard. If you click next hear, you will be at
the 'Choose data source' . Can you see the file maker pro driver in the list?
If so you may be able to specify the rest of the info in hear.
"newie" wrote:
[vbcol=seagreen]
> We have the filemaker pro driver. However, it doesn't allow me to add the
> database name as you indicated. The DSN connection was created as a remote
> connection using the server address. I am able to import the data using
> excel without any problems using the FileMaker Pro DSN connection. I tried
> adding the filemaker pro as a server link but that didn't work either. Any
> other ideas?
> "bluefish" wrote:
|||The Data Source doesn't appear in the drop-down list.
"bluefish" wrote:
[vbcol=seagreen]
> Hi, If you have the drive, does that show up in the list if you try to DTS?
> you can right click on SQL Server database->All Tasks->Import data->
> will get you to Data Import Wizard. If you click next hear, you will be at
> the 'Choose data source' . Can you see the file maker pro driver in the list?
> If so you may be able to specify the rest of the info in hear.
>
>
> "newie" wrote: