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:
Showing posts with label pro. Show all posts
Showing posts with label pro. Show all posts
Monday, March 26, 2012
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 (ODB
C)
> and check if there is a ODBC Driver for filemaker database extension. I a
m
> not sure if they would have this required driver. When you click on the Ad
d,
> 'Create New ODBC Driver' window will pop up. Look in the name section to s
ee
> 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 remo
te
> connection using the server address. I am able to import the data using
> excel without any problems using the FileMaker Pro DSN connection. I trie
d
> adding the filemaker pro as a server link but that didn't work either. An
y
> 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 li
st?
> If so you may be able to specify the rest of the info in hear.
>
>
> "newie" wrote:
>
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 (ODB
C)
> and check if there is a ODBC Driver for filemaker database extension. I a
m
> not sure if they would have this required driver. When you click on the Ad
d,
> 'Create New ODBC Driver' window will pop up. Look in the name section to s
ee
> 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 remo
te
> connection using the server address. I am able to import the data using
> excel without any problems using the FileMaker Pro DSN connection. I trie
d
> adding the filemaker pro as a server link but that didn't work either. An
y
> 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 li
st?
> If so you may be able to specify the rest of the info in hear.
>
>
> "newie" wrote:
>
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:
> 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?|||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:
> 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:
> > 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?|||The Data Source doesn't appear in the drop-down list.
"bluefish" 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:
> > 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:
> >
> > > 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?sql
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:
> 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?|||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:
> 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:
> > 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?|||The Data Source doesn't appear in the drop-down list.
"bluefish" 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:
> > 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:
> >
> > > 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?sql
Wednesday, March 21, 2012
Import Excel Spreadsheet to SQL 7
Running SQL Server 7 and Excel 2002 on an Win XP Pro machine.
I created a database with two tables, ran a program that added some data to
both tables, then used the Data Transformation Services Export Wizard to
export the tables to an Excel workbook containing each table as a separate
spreadsheet. So far, so good.
I manually made a number of changes to the spreadsheets, altering some of
the values that had been exported, adding some more rows to one of the
spreadsheets and sorting the rows. Now when I go back to SQL Server and use
the Wizard to import the data back into the tables, not all of the data
comes back in. Of about 250+ rows in one of the tables, less than 200 of
them get imported. I don't see any errors when running the wizard. I did a
TRUNCATE TABLE in query analyzer before doing the import to clear all the
rows in each table.
Is there some kind of marker to put in the file that tells the import wizard
where to stop? For example, when printing a spreadsheet, you "set" the
print area. Is there a corresponding function to set the "import" area?
Thanks
John Schneider
When you export to Excel from SQL Server a named range is created on the
Excel worksheet. In Excel select Insert on the menu and then Name. You
should see a name in the dialog box. Click on it and update the range and
then the full data set should get imported to SQL server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Bingo! Thanks for the reply. I NEVER would have found that setting.
John
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:cP9tbKX0EHA.764@.cpmsftngxa10.phx.gbl...
> When you export to Excel from SQL Server a named range is created on the
> Excel worksheet. In Excel select Insert on the menu and then Name. You
> should see a name in the dialog box. Click on it and update the range and
> then the full data set should get imported to SQL server.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
I created a database with two tables, ran a program that added some data to
both tables, then used the Data Transformation Services Export Wizard to
export the tables to an Excel workbook containing each table as a separate
spreadsheet. So far, so good.
I manually made a number of changes to the spreadsheets, altering some of
the values that had been exported, adding some more rows to one of the
spreadsheets and sorting the rows. Now when I go back to SQL Server and use
the Wizard to import the data back into the tables, not all of the data
comes back in. Of about 250+ rows in one of the tables, less than 200 of
them get imported. I don't see any errors when running the wizard. I did a
TRUNCATE TABLE in query analyzer before doing the import to clear all the
rows in each table.
Is there some kind of marker to put in the file that tells the import wizard
where to stop? For example, when printing a spreadsheet, you "set" the
print area. Is there a corresponding function to set the "import" area?
Thanks
John Schneider
When you export to Excel from SQL Server a named range is created on the
Excel worksheet. In Excel select Insert on the menu and then Name. You
should see a name in the dialog box. Click on it and update the range and
then the full data set should get imported to SQL server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Bingo! Thanks for the reply. I NEVER would have found that setting.
John
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:cP9tbKX0EHA.764@.cpmsftngxa10.phx.gbl...
> When you export to Excel from SQL Server a named range is created on the
> Excel worksheet. In Excel select Insert on the menu and then Name. You
> should see a name in the dialog box. Click on it and update the range and
> then the full data set should get imported to SQL server.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
Subscribe to:
Posts (Atom)