Stored Procedure for pumping in data

[chezzcake]

How is it possible for me to extract data out from a CD-Rom into the database without overwriting the existing data that is in the server?? Right now, the CD-Rom that was supplied to us by the suppiler overwrites the existing data in the server..

Now, my boss wants me to do a brand new stored procedure.. but I'm a newbie in using sql.

Any help will be greatly appreciated..

 

[tlbroadbent]

It would be helpful to know the format of the data being imported, the version of SQL Server, the schema of the tables, etc.

You can create your own proc to import date to the same tables. The current procedure probably truncates or deletes all of the data. Your new procedure would not do that. You would simply insert records into the table. This will work unless the data violates table constraints.

You may want to create another table for the new data. You can create a stored proc to import the data but you may find that DTS or BCP is more efficient. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[chezzcake]

The data format is in .xml and the server version is 97.
Each data file is in various text file

 

[tlbroadbent]

When you say the Version is 97, are you referring to MS Access? SQL Server versions are 6.5, 7 and 2000. If you are using Access, I suggest asking your question in an Access forum. If you are using SQL Server, please clarify the version and what additional info you may need.

Access forums:

Forum181 - Forum700 - Forum701 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[chezzcake]

Opps.. sorry, a typo error there.. it's server 7. Now the problem is: there is no sqlxml for server 7 that I can download to convert the xml format data. Those I can find are for server 2000.

 

[tlbroadbent]

SQLXML 2.0 does not support SQL 7. I don't know if you can even find an earlier version of SQLXML to download now that Microsoft no longer supports it for SQL 7. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[cmmrfrds]

If you don't find a tool, ADO is a possibility.
You can read and write an xml file with ADO, so, this would be possible with front end tools like VB, Access, ASP, etc.. An xml file in ADO can be treated like a recordset using the same ADO syntax as an SQL recordset.

ADO reference book: Serious ADO by Rob Macdonald