I need to copy the data in two spreadsheets into two
tables in "SQL Server 2000". Below are the details:


One spreadsheet contains the data that needs to be added
to an existing table in SQL server. All field names in the
spreadsheet match the DB table column names.
Another spreadsheet contains the data that needs to be
copied to a new DB table. The table currently does NOT
exist in the DB.

I'm not sure how to accomplish this. ANy help would be
appreciated.

Answer is the name of the group you posted the question in. Use dts
(data transformation services).
If you want further help with it let me know.
"Janice" <Janice.potucek (AT) nextiraone (DOT) com> wrote

Thank you much!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

SQLGUY.. you said if I needed more help!!!

The spreadsheet I was given to import has 24 columns and 76 rows. all
column names are the same in the source and destination - in other
words, the first row in the spreadsheet match the column headings in the
sql server table i'm importing to.

Maybe this is an easy thing and i'm just missing something.. but I get
this error trying to import:

first, on the 'select sources tables and views' it is giving me THREE
source tables to select from. I choose all three and then change my
destination to the destination SQL Table.

When I run it, I get errors stating somrthing like NULL not allowed.

any ideas?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You may need to open up a little and tell us more about your situation but
if I read that you are having problems with NULL and Excel spreadsheets then
maybe you are experiencing this

Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Janice Potucek" <janice.potucek (AT) nextiraone (DOT) com> wrote

I changed one of the rows in the table on the SQL server side to accept
a NULL Value so I fixed that problem. I guess what I'm confused about
it the fact that I CHOOSE THE ONE SPREADSHEETAS THE SOURCE and then on
the 'select sources tables and views' AND IT IS GIVING ME THREE
source tables to select from !!!!! AND THEN When I go ahead and select
all three and choose my SQL table to import them into, I'm not getting
this error:

Violation of Primary Key constraint 'PK_Faultresolutions' cannot insert
duplicate Key in FaultResolutions

I'm thinking maybe my spreadsheet is formatted incorrectly?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You select _ALL_ three ? How?

Excel will expose Named ranges and tables to you so you may see

Sheet1 and Sheet1$

What exactly do you see?

On a new Spreadsheet I see

Sheet1$
Sheet2$
Sheet3$

These correcpond to the Worksheets inside my Spreadsheet.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Janice Potucek" <janice.potucek (AT) nextiraone (DOT) com> wrote

On a NEW spreadsheet, I also see sheet
Sheet1$
Sheet2$
Sheet3$

The spreadsheet I'm trying to import has ONE worksheet called Voice.
Yet when I do the Import, it shows THREE worksheets to import:

Voice$
Voice$Print_Area
Voice$Print_Titles

???

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Ahhhhhh

Now i see

These are named ranges which appear as tables to DTS


In Excel look at the top left corner below the save button. You will see a
dropdown box. In there you should see the things about which we are talking.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Janice Potucek" <janice.potucek (AT) nextiraone (DOT) com> wrote

Now I feel dumb!! I did the import and chose ONLY the Voice$ worksheet
and it worked. However, I have one more question. The only way I
can get it to work is to the query builder in DTS and 'deselect' columns
called:

F25
F26
F27
F28
F29

??

I don't know where these came from as I don't see them in my
worksheet.??? Any idea where they came from? and am I losing Data
doing it this way???

Thank you for your patience with me and ALL THE HELP!!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!