SQL Server import/export Questions

1

DBFs into SQL Server 2008
Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the “import into Access, then import the Access files into SQL server-method”)? I don’t work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once [...]

Answer Question   |  June 4, 2010  3:28 PM
DBF file, SQL Server 2008, SQL Server import/export
asked by:
16,755 pts.

Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the [...]

Answer Question   |  February 16, 2009  7:09 PM
Database connectivity, DSN connection, Microsoft Access, Microsoft Excel, SQL Server connectivity, SQL Server import/export
asked by:
5 pts.

Migrating data from Microsoft Access to SQL Server 2000
I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

Answer Question   |  December 9, 2008  8:00 AM
Database migration, Microsoft Access, Microsoft Access import/export, SQL Server 2000, SQL Server 2000 import/export, SQL Server import/export, Windows Services
asked by:
5 pts.

How to upload data from Excel into SQL Server 2005
hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav

Answer Question   |  November 25, 2008  12:59 PM
Microsoft Excel, Microsoft Excel import/export, SQL Server 2005 import/export, SQL Server import/export
asked by:
310 pts.

Updating Microsoft SQL Server tables from Oracle generates error
i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: “NAME”: invalid identifier.

Answer Question   |  October 22, 2008  8:58 AM
Microsoft SQL Server 2000, ORA-00904, Oracle error messages, Oracle import/export, SQL Server 2000, SQL Server import/export
asked by:
10 pts.

Transferring SQL 7 DB to SQL 2005 DB
Hi to all, I have a Dell PowerEdge server having an SQL 7 DB on it and I want to transfer these DB to the new IBM Server having an SQL 2005 Server Standard Edition. I am not experienced enough to database administration. Can someone guide me thru this pls. Thanks, Bert

Answer Question   |  December 11, 2008  9:33 AM
Dell PowerEdge, SQL Server 2005, SQL Server 7.x, SQL Server import/export, SQL Server migration
asked by:
40 pts.

Is it possible to copy system DBs to another server?
Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost [...]

Answer Question   |  October 9, 2008  3:38 AM
SQL Server 2005, SQL Server import/export, SQL Server migration, SQL Server replication
asked by:
290 pts.

Creating XML file using SQL Server 2005
How to create a xml file using sql server 2005? what are all the steps to do for this?

Answer Question   |  October 9, 2008  4:54 AM
SQL Server 2005, SQL Server import/export, XML
asked by:
5 pts.

For Save .doc file in Sql Server 2000
I want to Save Word File in SQl Server, how it is possible

Answer Question   |  September 19, 2008  6:31 AM
Microsoft Word, SQL Server 2000, SQL Server import/export
asked by:
5 pts.

Error when translating execute immediate from Oracle to SQL
SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = ‘Avi’ /* * SSMA error messages: * O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(…) statement, but dynamic string was not converted. It must be converted manually. * [...]

Answer Question   |  August 16, 2010  7:31 AM
O2SS0013, O2SS0356, Oracle error messages, Oracle import/export, Oracle migration, SQL Server import/export, SQL Server Migration Assistant, SSMA, SSMA for Oracle, SSMA warning messages
asked by:
5 pts.

Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format
i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.

Answer Question   |  September 8, 2008  5:33 AM
SQL Server 2000, SQL Server import/export, XML
asked by:
10 pts.

Saving Query results into Excel format
How can I save query results into .xls format directly from Microsoft SQL server Management studio?

Answer Question   |  September 5, 2008  1:43 AM
Microsoft Excel, SQL Server 2005, SQL Server import/export
asked by:
5 pts.

I want to load XML to a table in SQL Server 2005
i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

Answer Question   |  March 4, 2011  8:58 AM
SQL Server 2005, SQL Server import/export, XML
asked by:
10 pts.

Oracle to SQL Server Migration – CURSOR type conversion
When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

Answer Question   |  August 25, 2008  1:42 AM
Database migration, Oracle import/export, SQL Server 2005, SQL Server import/export, SSMA for Oracle
asked by:
25 pts.

Oracle to SQL Server Migration – User Defined data types
Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

Answer Question   |  August 28, 2008  1:38 AM
Database migration, Oracle import/export, Oracle migration, SQL Server 2005, SQL Server import/export, SSMA for Oracle
asked by:
25 pts.

SQL 2005 to .XML
How do I automate 2 sql servers to replicate .xml files

Answer Question   |  August 22, 2008  9:13 AM
SQL Server 2005, SQL Server import/export, SQL Server replication, XML
asked by:
5 pts.

xml create form sql database
i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file

Answer Question   |  August 7, 2008  5:22 AM
SQL Server import/export, XML
asked by:
5 pts.

1