How can I move/import .MDF file to another machine ?

Our SQL Server machine just crashed, but I can get to the .MDF file (not a
backup file). If I have the .MDF file of a SQL Server database, can I import
this file to another SQL Server and look at it at the new machine ?
Thanks.
If the SQL Server crashed in a weird state, you MIGHT be able to recover the
file.
Copy the MDF and LDF files to the other machine, and try attaching them.
(Look at sp_attach_db in Books Online).
If that fails, you can try just the MDF file, using sp_attach_single_file_db
(also documented in books online).
If that also fails, then you might have just learned the value of backups.
Better late than never. :-)
http://www.aspfaq.com/
(Reverse address to reply.)
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> Our SQL Server machine just crashed, but I can get to the .MDF file (not a
> backup file). If I have the .MDF file of a SQL Server database, can I
import
> this file to another SQL Server and look at it at the new machine ?
> Thanks.
|||Thank you.
I do not have the LDF file, and when I tried sp_attach_single_file_db
I got an error saying something like the MDF file does not have the right
format, or something like that.
I already recommend them to backup next time.
Thank you for your help.
"Aaron [SQL Server MVP]" wrote:

> If the SQL Server crashed in a weird state, you MIGHT be able to recover the
> file.
> Copy the MDF and LDF files to the other machine, and try attaching them.
> (Look at sp_attach_db in Books Online).
> If that fails, you can try just the MDF file, using sp_attach_single_file_db
> (also documented in books online).
> If that also fails, then you might have just learned the value of backups.
> Better late than never. :-)
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
> news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> import
>
>
|||See if this helps:
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
This is why Backups are so important.
Andrew J. Kelly SQL MVP
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:7E0625EA-A06C-49B4-833A-232C4B11DAC5@.microsoft.com...[vbcol=seagreen]
> Thank you.
> I do not have the LDF file, and when I tried sp_attach_single_file_db
> I got an error saying something like the MDF file does not have the right
> format, or something like that.
> I already recommend them to backup next time.
> Thank you for your help.
> "Aaron [SQL Server MVP]" wrote:

How can I move/import .MDF file to another machine ?

Our SQL Server machine just crashed, but I can get to the .MDF file (not a
backup file). If I have the .MDF file of a SQL Server database, can I import
this file to another SQL Server and look at it at the new machine ?
Thanks.If the SQL Server crashed in a weird state, you MIGHT be able to recover the
file.
Copy the MDF and LDF files to the other machine, and try attaching them.
(Look at sp_attach_db in Books Online).
If that fails, you can try just the MDF file, using sp_attach_single_file_db
(also documented in books online).
If that also fails, then you might have just learned the value of backups.
Better late than never. :-)
http://www.aspfaq.com/
(Reverse address to reply.)
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> Our SQL Server machine just crashed, but I can get to the .MDF file (not a
> backup file). If I have the .MDF file of a SQL Server database, can I
import
> this file to another SQL Server and look at it at the new machine ?
> Thanks.|||Thank you.
I do not have the LDF file, and when I tried sp_attach_single_file_db
I got an error saying something like the MDF file does not have the right
format, or something like that.
I already recommend them to backup next time.
Thank you for your help.
"Aaron [SQL Server MVP]" wrote:

> If the SQL Server crashed in a weird state, you MIGHT be able to recover t
he
> file.
> Copy the MDF and LDF files to the other machine, and try attaching them.
> (Look at sp_attach_db in Books Online).
> If that fails, you can try just the MDF file, using sp_attach_single_file_
db
> (also documented in books online).
> If that also fails, then you might have just learned the value of backups.
> Better late than never. :-)
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
> news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> import
>
>|||See if this helps:
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
This is why Backups are so important.
Andrew J. Kelly SQL MVP
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:7E0625EA-A06C-49B4-833A-232C4B11DAC5@.microsoft.com...[vbcol=seagreen]
> Thank you.
> I do not have the LDF file, and when I tried sp_attach_single_file_db
> I got an error saying something like the MDF file does not have the right
> format, or something like that.
> I already recommend them to backup next time.
> Thank you for your help.
> "Aaron [SQL Server MVP]" wrote:
>sql

How can I move/import .MDF file to another machine ?

Our SQL Server machine just crashed, but I can get to the .MDF file (not a
backup file). If I have the .MDF file of a SQL Server database, can I import
this file to another SQL Server and look at it at the new machine ?
Thanks.If the SQL Server crashed in a weird state, you MIGHT be able to recover the
file.
Copy the MDF and LDF files to the other machine, and try attaching them.
(Look at sp_attach_db in Books Online).
If that fails, you can try just the MDF file, using sp_attach_single_file_db
(also documented in books online).
If that also fails, then you might have just learned the value of backups.
Better late than never. :-)
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> Our SQL Server machine just crashed, but I can get to the .MDF file (not a
> backup file). If I have the .MDF file of a SQL Server database, can I
import
> this file to another SQL Server and look at it at the new machine ?
> Thanks.|||Thank you.
I do not have the LDF file, and when I tried sp_attach_single_file_db
I got an error saying something like the MDF file does not have the right
format, or something like that.
I already recommend them to backup next time.
Thank you for your help.
"Aaron [SQL Server MVP]" wrote:
> If the SQL Server crashed in a weird state, you MIGHT be able to recover the
> file.
> Copy the MDF and LDF files to the other machine, and try attaching them.
> (Look at sp_attach_db in Books Online).
> If that fails, you can try just the MDF file, using sp_attach_single_file_db
> (also documented in books online).
> If that also fails, then you might have just learned the value of backups.
> Better late than never. :-)
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
> news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> > Our SQL Server machine just crashed, but I can get to the .MDF file (not a
> > backup file). If I have the .MDF file of a SQL Server database, can I
> import
> > this file to another SQL Server and look at it at the new machine ?
> > Thanks.
>
>|||See if this helps:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
This is why Backups are so important.
--
Andrew J. Kelly SQL MVP
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:7E0625EA-A06C-49B4-833A-232C4B11DAC5@.microsoft.com...
> Thank you.
> I do not have the LDF file, and when I tried sp_attach_single_file_db
> I got an error saying something like the MDF file does not have the right
> format, or something like that.
> I already recommend them to backup next time.
> Thank you for your help.
> "Aaron [SQL Server MVP]" wrote:
>> If the SQL Server crashed in a weird state, you MIGHT be able to recover
>> the
>> file.
>> Copy the MDF and LDF files to the other machine, and try attaching them.
>> (Look at sp_attach_db in Books Online).
>> If that fails, you can try just the MDF file, using
>> sp_attach_single_file_db
>> (also documented in books online).
>> If that also fails, then you might have just learned the value of
>> backups.
>> Better late than never. :-)
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
>> news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
>> > Our SQL Server machine just crashed, but I can get to the .MDF file
>> > (not a
>> > backup file). If I have the .MDF file of a SQL Server database, can I
>> import
>> > this file to another SQL Server and look at it at the new machine ?
>> > Thanks.
>>

How can I make a "template" of my database?

I have a situation where my database might be deleted every so oftern and I
would like to find a way to "import" sort of a "blank template" of the
original database. Is there a way to do this?
I realize that I could have my program code just create another database,
but that's kind of a hastle, so I was looking for an easier way.
res0gyio@.verizon.netIn Enterprise Manager, right click on the database, all tasks - Generate
script - then select the appropiate options you would like (I addtion to
selecting all your tables on the first tab, I suggest Indexs & defaults on
the last tab)
Mo
"michaaal" <res0gyio@.verizon.net> wrote in message
news:uBiT7mwCEHA.1600@.tk2msftngp13.phx.gbl...
> I have a situation where my database might be deleted every so oftern and
I
> would like to find a way to "import" sort of a "blank template" of the
> original database. Is there a way to do this?
> I realize that I could have my program code just create another database,
> but that's kind of a hastle, so I was looking for an easier way.
> res0gyio@.verizon.net
>|||Almost forgot to mention, you can run the script in Query Analyzer to
re-structure your databases (it'll also wipe it out first if you selected
the "drop table" option while creating the script)
Mo
"michaaal" <res0gyio@.verizon.net> wrote in message
news:uBiT7mwCEHA.1600@.tk2msftngp13.phx.gbl...
> I have a situation where my database might be deleted every so oftern and
I
> would like to find a way to "import" sort of a "blank template" of the
> original database. Is there a way to do this?
> I realize that I could have my program code just create another database,
> but that's kind of a hastle, so I was looking for an easier way.
> res0gyio@.verizon.net
>|||A lots of tools and options to generate DDL scripts:
http://www.karaszi.com/sqlserver/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"michaaal" <res0gyio@.verizon.net> wrote in message
news:uBiT7mwCEHA.1600@.tk2msftngp13.phx.gbl...
> I have a situation where my database might be deleted every so oftern and
I
> would like to find a way to "import" sort of a "blank template" of the
> original database. Is there a way to do this?
> I realize that I could have my program code just create another database,
> but that's kind of a hastle, so I was looking for an easier way.
> res0gyio@.verizon.net
>

How can I increase the maximum number of parallel connections when exporting to Oracle via

Hi to everybody,
When exporting to Oracle from SQL Server using Import/Export Wizard,
I've discovered that SQL Server only creates 4 simultaneous
connections to Oracle. Obviously this fact prevents SQL Server from
exporting the tables in a parallel way. Instead, the tables are forced
to wait until one of the 4 connections gets free to export and due to
this fact the performance of the export operation suffers from an
enormous slow down.
Even though I create new connections in the DTS Designer (up to 20),
SQL Server 2K continues only using the same 4 ones which makes me
suspect that there must be a hidden option somewhere to change this.
Is there any way in SQL Server 2K to increase the number of maximum
simultaneous connections to Oracle?
Thank your from beforehand for reading my post.
Greetings,
David GrantBy default, DTS executes only 4 tasks concurrently. Check how to change this
at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsdsgnr/dtsdsgnr2_60mp.asp
(the last option on the General tab of package properties).
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0504181032.2b96883c@.posting.google.com...
> Hi to everybody,
> When exporting to Oracle from SQL Server using Import/Export Wizard,
> I've discovered that SQL Server only creates 4 simultaneous
> connections to Oracle. Obviously this fact prevents SQL Server from
> exporting the tables in a parallel way. Instead, the tables are forced
> to wait until one of the 4 connections gets free to export and due to
> this fact the performance of the export operation suffers from an
> enormous slow down.
>
> Even though I create new connections in the DTS Designer (up to 20),
> SQL Server 2K continues only using the same 4 ones which makes me
> suspect that there must be a hidden option somewhere to change this.
> Is there any way in SQL Server 2K to increase the number of maximum
> simultaneous connections to Oracle?
>
> Thank your from beforehand for reading my post.
> Greetings,
> David Grant|||In addition to Dejan's excellent advice, note that you will need to look at how optimal hiking the tasks in parallel actually is.
If you are running on a 4 way then hiking this value to 20 would not be a good thing and you would see a lot of context switches as
things come in and off the processors. I would start with CPU Count -1
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message news:%23RTgwCFRFHA.204@.TK2MSFTNGP15.phx.gbl...
> By default, DTS executes only 4 tasks concurrently. Check how to change this
> at
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsdsgnr/dtsdsgnr2_60mp.asp
> (the last option on the General tab of package properties).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "David Grant" <icebold54@.hotmail.com> wrote in message
> news:18503386.0504181032.2b96883c@.posting.google.com...
>> Hi to everybody,
>> When exporting to Oracle from SQL Server using Import/Export Wizard,
>> I've discovered that SQL Server only creates 4 simultaneous
>> connections to Oracle. Obviously this fact prevents SQL Server from
>> exporting the tables in a parallel way. Instead, the tables are forced
>> to wait until one of the 4 connections gets free to export and due to
>> this fact the performance of the export operation suffers from an
>> enormous slow down.
>>
>> Even though I create new connections in the DTS Designer (up to 20),
>> SQL Server 2K continues only using the same 4 ones which makes me
>> suspect that there must be a hidden option somewhere to change this.
>> Is there any way in SQL Server 2K to increase the number of maximum
>> simultaneous connections to Oracle?
>>
>> Thank your from beforehand for reading my post.
>> Greetings,
>> David Grant
>

How can I increase the maximum number of parallel connections when exporting to Oracle via

Hi to everybody,
When exporting to Oracle from SQL Server using Import/Export Wizard,
I've discovered that SQL Server only creates 4 simultaneous
connections to Oracle. Obviously this fact prevents SQL Server from
exporting the tables in a parallel way. Instead, the tables are forced
to wait until one of the 4 connections gets free to export and due to
this fact the performance of the export operation suffers from an
enormous slow down.
Even though I create new connections in the DTS Designer (up to 20),
SQL Server 2K continues only using the same 4 ones which makes me
suspect that there must be a hidden option somewhere to change this.
Is there any way in SQL Server 2K to increase the number of maximum
simultaneous connections to Oracle?
Thank your from beforehand for reading my post.
Greetings,
David Grant
By default, DTS executes only 4 tasks concurrently. Check how to change this
at
http://msdn.microsoft.com/library/de...sgnr2_60mp.asp
(the last option on the General tab of package properties).
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0504181032.2b96883c@.posting.google.c om...
> Hi to everybody,
> When exporting to Oracle from SQL Server using Import/Export Wizard,
> I've discovered that SQL Server only creates 4 simultaneous
> connections to Oracle. Obviously this fact prevents SQL Server from
> exporting the tables in a parallel way. Instead, the tables are forced
> to wait until one of the 4 connections gets free to export and due to
> this fact the performance of the export operation suffers from an
> enormous slow down.
>
> Even though I create new connections in the DTS Designer (up to 20),
> SQL Server 2K continues only using the same 4 ones which makes me
> suspect that there must be a hidden option somewhere to change this.
> Is there any way in SQL Server 2K to increase the number of maximum
> simultaneous connections to Oracle?
>
> Thank your from beforehand for reading my post.
> Greetings,
> David Grant
|||In addition to Dejan's excellent advice, note that you will need to look at how optimal hiking the tasks in parallel actually is.
If you are running on a 4 way then hiking this value to 20 would not be a good thing and you would see a lot of context switches as
things come in and off the processors. I would start with CPU Count -1

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message news:%23RTgwCFRFHA.204@.TK2MSFTNGP15.phx.gbl...
> By default, DTS executes only 4 tasks concurrently. Check how to change this
> at
> http://msdn.microsoft.com/library/de...sgnr2_60mp.asp
> (the last option on the General tab of package properties).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "David Grant" <icebold54@.hotmail.com> wrote in message
> news:18503386.0504181032.2b96883c@.posting.google.c om...
>

How can I increase the maximum number of parallel connections when exporting to Oracle via

Hi to everybody,
When exporting to Oracle from SQL Server using Import/Export Wizard,
I've discovered that SQL Server only creates 4 simultaneous
connections to Oracle. Obviously this fact prevents SQL Server from
exporting the tables in a parallel way. Instead, the tables are forced
to wait until one of the 4 connections gets free to export and due to
this fact the performance of the export operation suffers from an
enormous slow down.
Even though I create new connections in the DTS Designer (up to 20),
SQL Server 2K continues only using the same 4 ones which makes me
suspect that there must be a hidden option somewhere to change this.
Is there any way in SQL Server 2K to increase the number of maximum
simultaneous connections to Oracle?
Thank your from beforehand for reading my post.
Greetings,
David Grant
By default, DTS executes only 4 tasks concurrently. Check how to change this
at
http://msdn.microsoft.com/library/de...sgnr2_60mp.asp
(the last option on the General tab of package properties).
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0504181032.2b96883c@.posting.google.c om...
> Hi to everybody,
> When exporting to Oracle from SQL Server using Import/Export Wizard,
> I've discovered that SQL Server only creates 4 simultaneous
> connections to Oracle. Obviously this fact prevents SQL Server from
> exporting the tables in a parallel way. Instead, the tables are forced
> to wait until one of the 4 connections gets free to export and due to
> this fact the performance of the export operation suffers from an
> enormous slow down.
>
> Even though I create new connections in the DTS Designer (up to 20),
> SQL Server 2K continues only using the same 4 ones which makes me
> suspect that there must be a hidden option somewhere to change this.
> Is there any way in SQL Server 2K to increase the number of maximum
> simultaneous connections to Oracle?
>
> Thank your from beforehand for reading my post.
> Greetings,
> David Grant
|||In addition to Dejan's excellent advice, note that you will need to look at how optimal hiking the tasks in parallel actually is.
If you are running on a 4 way then hiking this value to 20 would not be a good thing and you would see a lot of context switches as
things come in and off the processors. I would start with CPU Count -1

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message news:%23RTgwCFRFHA.204@.TK2MSFTNGP15.phx.gbl...
> By default, DTS executes only 4 tasks concurrently. Check how to change this
> at
> http://msdn.microsoft.com/library/de...sgnr2_60mp.asp
> (the last option on the General tab of package properties).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "David Grant" <icebold54@.hotmail.com> wrote in message
> news:18503386.0504181032.2b96883c@.posting.google.c om...
>

How can I increase the maximum number of parallel connections when exporting to Oracle

Hi to everybody,
When exporting to Oracle from SQL Server using Import/Export Wizard,
I've discovered that SQL Server only creates 4 simultaneous
connections to Oracle. Obviously this fact prevents SQL Server from
exporting the tables in a parallel way. Instead, the tables are forced
to wait until one of the 4 connections gets free to export and due to
this fact the performance of the export operation suffers from an
enormous slow down.
Even though I create new connections in the DTS Designer (up to 20),
SQL Server 2K continues only using the same 4 ones which makes me
suspect that there must be a hidden option somewhere to change this.
Is there any way in SQL Server 2K to increase the number of maximum
simultaneous connections to Oracle?
Thank your from beforehand for reading my post.
Greetings,
David GrantBy default, DTS executes only 4 tasks concurrently. Check how to change this
at
2_60mp.asp" target="_blank">http://msdn.microsoft.com/library/d... />
2_60mp.asp
(the last option on the General tab of package properties).
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0504181032.2b96883c@.posting.google.com...
> Hi to everybody,
> When exporting to Oracle from SQL Server using Import/Export Wizard,
> I've discovered that SQL Server only creates 4 simultaneous
> connections to Oracle. Obviously this fact prevents SQL Server from
> exporting the tables in a parallel way. Instead, the tables are forced
> to wait until one of the 4 connections gets free to export and due to
> this fact the performance of the export operation suffers from an
> enormous slow down.
>
> Even though I create new connections in the DTS Designer (up to 20),
> SQL Server 2K continues only using the same 4 ones which makes me
> suspect that there must be a hidden option somewhere to change this.
> Is there any way in SQL Server 2K to increase the number of maximum
> simultaneous connections to Oracle?
>
> Thank your from beforehand for reading my post.
> Greetings,
> David Grant|||In addition to Dejan's excellent advice, note that you will need to look at
how optimal hiking the tasks in parallel actually is.
If you are running on a 4 way then hiking this value to 20 would not be a go
od thing and you would see a lot of context switches as
things come in and off the processors. I would start with CPU Count -1
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message news:%23R
TgwCFRFHA.204@.TK2MSFTNGP15.phx.gbl...
> By default, DTS executes only 4 tasks concurrently. Check how to change th
is
> at
> nr2_60mp.asp" target="_blank">http://msdn.microsoft.com/library/d...>
nr2_60mp.asp
> (the last option on the General tab of package properties).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "David Grant" <icebold54@.hotmail.com> wrote in message
> news:18503386.0504181032.2b96883c@.posting.google.com...
>

How can I import txt files using fdf field info ??

I have many ca. 1-5 Gb fixed field width txt files to import into a SQL
Server database. They were apparently exported from SAP, and each came with
a corresponding fdf file that lists the field layout information ...
PCFDF
PCFT 1
PCFO 1,1,1,1,1
PCFL YR 1 2
PCFL DIV 1 18
...
PCFL E12 2 13/3
Is there any way that I can get Enterprise Manager to use this information,
rather than forcing me to enter it manually ? Alternatively, is there a
third party app that'll do that ? The layouts are not necessarily
identical for all the files, so I really need to use the information from
each file's corresponding fdf.
Thanks
--
Jim Cook
jimcook@.panix.com.no.spamJim
you can easily import text files. withEM
EM> right click on Data Transformation services > import data and give path
of .txt
This is abt txt. I dont know about sap
Regards
R.D
"Jim Cook" wrote:
> I have many ca. 1-5 Gb fixed field width txt files to import into a SQL
> Server database. They were apparently exported from SAP, and each came with
> a corresponding fdf file that lists the field layout information ...
> PCFDF
> PCFT 1
> PCFO 1,1,1,1,1
> PCFL YR 1 2
> PCFL DIV 1 18
> ...
> PCFL E12 2 13/3
> Is there any way that I can get Enterprise Manager to use this information,
> rather than forcing me to enter it manually ? Alternatively, is there a
> third party app that'll do that ? The layouts are not necessarily
> identical for all the files, so I really need to use the information from
> each file's corresponding fdf.
> Thanks
> --
> Jim Cook
> jimcook@.panix.com.no.spam
>|||Yes, I've done that - but the wizard gets to a window where it wants me to
click where each field ends and the next begins. I have that information in
the fdf files, but I do not want to go through the process of defining ~100
field spans for ~20 files. I strongly suspect that the fdf files were
created by SAP during the export operation, but they're apparently not
recognized by EM as proper import templates. So what I'm looking for is an
app that converts the fdf files to EM's import template format, or natively
uses fdf files in doing SQL Server imports. I've done a fair amount of
googling, and have found leads re using fdfs in MySQL imports, but nada re
SQL Server imports.
--
Jim Cook
jimcook@.panix.com.no.spam
"R.D" wrote:
> Jim
> you can easily import text files. withEM
> EM> right click on Data Transformation services > import data and give path
> of .txt
> This is abt txt. I dont know about sap
> Regards
> R.D
>
> "Jim Cook" wrote:
> > I have many ca. 1-5 Gb fixed field width txt files to import into a SQL
> > Server database. They were apparently exported from SAP, and each came with
> > a corresponding fdf file that lists the field layout information ...
> >
> > PCFDF
> > PCFT 1
> > PCFO 1,1,1,1,1
> > PCFL YR 1 2
> > PCFL DIV 1 18
> > ...
> > PCFL E12 2 13/3
> >
> > Is there any way that I can get Enterprise Manager to use this information,
> > rather than forcing me to enter it manually ? Alternatively, is there a
> > third party app that'll do that ? The layouts are not necessarily
> > identical for all the files, so I really need to use the information from
> > each file's corresponding fdf.
> >
> > Thanks
> > --
> > Jim Cook
> > jimcook@.panix.com.no.spam
> >

How can I import txt files using fdf field info ??

I have many ca. 1-5 Gb fixed field width txt files to import into a SQL
Server database. They were apparently exported from SAP, and each came with
a corresponding fdf file that lists the field layout information ...
PCFDF
PCFT 1
PCFO 1,1,1,1,1
PCFL YR 1 2
PCFL DIV 1 18
...
PCFL E12 2 13/3
Is there any way that I can get Enterprise Manager to use this information,
rather than forcing me to enter it manually ? Alternatively, is there a
third party app that'll do that ? The layouts are not necessarily
identical for all the files, so I really need to use the information from
each file's corresponding fdf.
Thanks
Jim Cook
jimcook@.panix.com.no.spam
Jim
you can easily import text files. withEM
EM> right click on Data Transformation services > import data and give path
of .txt
This is abt txt. I dont know about sap
Regards
R.D
"Jim Cook" wrote:

> I have many ca. 1-5 Gb fixed field width txt files to import into a SQL
> Server database. They were apparently exported from SAP, and each came with
> a corresponding fdf file that lists the field layout information ...
> PCFDF
> PCFT 1
> PCFO 1,1,1,1,1
> PCFL YR 1 2
> PCFL DIV 1 18
> ...
> PCFL E12 2 13/3
> Is there any way that I can get Enterprise Manager to use this information,
> rather than forcing me to enter it manually ? Alternatively, is there a
> third party app that'll do that ? The layouts are not necessarily
> identical for all the files, so I really need to use the information from
> each file's corresponding fdf.
> Thanks
> --
> Jim Cook
> jimcook@.panix.com.no.spam
>
|||Yes, I've done that - but the wizard gets to a window where it wants me to
click where each field ends and the next begins. I have that information in
the fdf files, but I do not want to go through the process of defining ~100
field spans for ~20 files. I strongly suspect that the fdf files were
created by SAP during the export operation, but they're apparently not
recognized by EM as proper import templates. So what I'm looking for is an
app that converts the fdf files to EM's import template format, or natively
uses fdf files in doing SQL Server imports. I've done a fair amount of
googling, and have found leads re using fdfs in MySQL imports, but nada re
SQL Server imports.
Jim Cook
jimcook@.panix.com.no.spam
"R.D" wrote:
[vbcol=seagreen]
> Jim
> you can easily import text files. withEM
> EM> right click on Data Transformation services > import data and give path
> of .txt
> This is abt txt. I dont know about sap
> Regards
> R.D
>
> "Jim Cook" wrote:

How can I import txt files using fdf field info ??

I have many ca. 1-5 Gb fixed field width txt files to import into a SQL
Server database. They were apparently exported from SAP, and each came with
a corresponding fdf file that lists the field layout information ...
PCFDF
PCFT 1
PCFO 1,1,1,1,1
PCFL YR 1 2
PCFL DIV 1 18
...
PCFL E12 2 13/3
Is there any way that I can get Enterprise Manager to use this information,
rather than forcing me to enter it manually ? Alternatively, is there a
third party app that'll do that ? The layouts are not necessarily
identical for all the files, so I really need to use the information from
each file's corresponding fdf.
Thanks
--
Jim Cook
jimcook@.panix.com.no.spamJim
you can easily import text files. withEM
EM> right click on Data Transformation services > import data and give path
of .txt
This is abt txt. I dont know about sap
Regards
R.D
"Jim Cook" wrote:

> I have many ca. 1-5 Gb fixed field width txt files to import into a SQL
> Server database. They were apparently exported from SAP, and each came wi
th
> a corresponding fdf file that lists the field layout information ...
> PCFDF
> PCFT 1
> PCFO 1,1,1,1,1
> PCFL YR 1 2
> PCFL DIV 1 18
> ...
> PCFL E12 2 13/3
> Is there any way that I can get Enterprise Manager to use this information
,
> rather than forcing me to enter it manually ? Alternatively, is there a
> third party app that'll do that ? The layouts are not necessarily
> identical for all the files, so I really need to use the information from
> each file's corresponding fdf.
> Thanks
> --
> Jim Cook
> jimcook@.panix.com.no.spam
>|||Yes, I've done that - but the wizard gets to a window where it wants me to
click where each field ends and the next begins. I have that information in
the fdf files, but I do not want to go through the process of defining ~100
field spans for ~20 files. I strongly suspect that the fdf files were
created by SAP during the export operation, but they're apparently not
recognized by EM as proper import templates. So what I'm looking for is an
app that converts the fdf files to EM's import template format, or natively
uses fdf files in doing SQL Server imports. I've done a fair amount of
googling, and have found leads re using fdfs in mysql imports, but nada re
SQL Server imports.
Jim Cook
jimcook@.panix.com.no.spam
"R.D" wrote:
[vbcol=seagreen]
> Jim
> you can easily import text files. withEM
> EM> right click on Data Transformation services > import data and give pat
h
> of .txt
> This is abt txt. I dont know about sap
> Regards
> R.D
>
> "Jim Cook" wrote:
>

how can i import the northwind DB into ms sql server 2005?

i hava tried installing the "SQL2000SampleDb" but the db is not

on the db list after the install

Make sure that you installed the DBs on the right instance you are connecting to. Additionally make sure that the script executed successfully. If you are not sure just rerun the script, the db will be dropped and recreated then.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

How can i import the data from other database into SQL server ?

Hi,
i have developed an web-enabled student database application, where in i'll put all the details of the students from different universities.
while uploading the details of the students, i wanna just import the data given by the universities into the server.
I dont know how exactly the same could be done, also, since each university might be having there own format for the data, how can i import these into singe database?
Any ideas ... Please.
Thanks in advance

Hi,
you can use DTS (Data Transformation Services) from Enterprise manager of Sql Server.
Regards
|||DTS is the way to go. If you have a standard your format, you can upload the file then launch the DTS package from your web page instead of having to upload the file then go to Ent Mgr, just simplifies things a bit. If that's what you are going to do, I'll provide VB code on how to launch the DTS pkg from you web page.|||Hey thanx,
i cant standardise the format since each university will have there own.And they all cant afford to give the data in the standard format.
anyways, do me the favour by providing me the code.If possible make it in C# since thats the one which i am coding with .
Also, can u plz give me an idea to how exactly i can standardise the format.
thanks in advance

How can I import table indices for all the tables transferred from one db to Sql Server?

Hello,
I was successfully able to import all the tables from a SQLBase db to MSSQL.
Now i would also like to import all the indexes for the tables.
How can I do that?
Regards,
Sami
[Remove Numbers from e-mail address to use it]
The only way I can think of would be if SQLBase has metadata tables from
which you can query for the indexes. You could query them and create
the CREATE INDEX statements required on SQL Server and then run them.
There is no part of Native DTS that will do this for you though.
Allan
"Sami" <s8a2m9i1_i5s1l9a6m@.hotmail.com> wrote in message
news:s8a2m9i1_i5s1l9a6m@.hotmail.com:

> Hello,
> I was successfully able to import all the tables from a SQLBase db to MSSQL.
> Now i would also like to import all the indexes for the tables.
> How can I do that?
> --
> Regards,
> Sami
> [Remove Numbers from e-mail address to use it]

How can i import records from a sql server table in project1 to another sql server table i

Hi, i have a table with all employee bio-data in a completed project. Iam now working on another project with a table that needs the same data and here iam talking about 300 records that rarely change. Instead of re-entering this data in this new table, i want to import the data from the completed project into a table in this new project. Does any one have any idea how to achieve that or is there a better option to do the same.

One more thing iam realising here is that iam going to use this same data in very many applications and some one from one department is going to enter this data in all these different applications. so i was wondering if there could be a way of having a central database that this guy can mantain and then i be able to use that table data in different applications that iam going to develop. I dont want to kill this unlucky guy with data entry tasks every time i deploy a new application.

So basically, how can make one database application sever several different applications with its data.

Why hold the database within the project at all? Move the database to the server, create one account for updating and one other applications that just need to read the data.

|||

You can share database for different projects. You can copy database tables from one database to another. Here is a sample for you to move one table from one database to another database without creating the new table first.

Run this from the database you want to export data:

SELECT*INTO newDataBaseName.dbo.yourNewTableFROM tableToExpost

|||

TATWORTH:

Why hold the database within the project at all? Move the database to the server, create one account for updating and one other applications that just need to read the data.

Iam running sql sever express 2005 with advanced services and visual web developer 2005 express edition. I also got info some where on msdn that sql sever express does not support multiple connections to a .mdf file. If this is true, then wont i run into error like

1. A connection can not be made, the file is being used by a nother process or application.

2. The database is closed.

|||

From http://msdn2.microsoft.com/en-us/library/ms345154.aspx#sseover_topic19

QL Server Express 2005MSDE 2000User Instance supportFeature not presentDTS in separate downloadDTS runtime presentEasy deployment because of no MDACMDAC is part of installMSI only, good servicing storyMSI and MSM, servicing of MSM hardSubscriber Replication for Transactional, Merge, and snapshotMerge/snapshot publication supported in addition to replication subscriptionRobust setup UIBasic setup UINo agentAgent presentSupports Windows 2000 SP4, Windows XP SP1, and Windows 2003Supports Windows 98, Windows Me, Windows 2000, Windows XP, Windows NT4, and Windows 2003CLR supportNo CLR supportGUI tools availableNo GUI toolsDatabase size limit: 4 GBDatabase size limit: 2 GB1 CPU, 1 GB RAM2 CPU, 2 GB RAMNo throttleWorkload throttle enforced for 5 concurrent workloadsDeep integration with Visual StudioBasic integration with Visual Studio

The phrase "No Throttle" implies that a given database can be used by more than one process.

how can i import file excel in SQL2005

how can i import data from excel file to SQL2005 to create new table or insert data from excel file to table. USING sql statement.
i want to use on C# , on C# i use what connect to control this action.
thanks alot.You could use OPENROWSET table value function for opening any OLEDB datasource:
--Create table XLImport and inserts data:
SELECT * INTO XLImport
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

--Insert data into existed table
INSERT INTO XLImport
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

Other approaches: http://support.microsoft.com/kb/321686|||Thanks for answer me;
But it return error :

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

i'm trying to connect using sql author.. but it return the same error;
help me, thanks alot|||Open Start->Programs->SQLServer...->Configuration....->Surface Area Configuration, then click by Features link and enable 'Ad Hoc Distributed Queries'|||

Konstantin Kosinsky wrote:

Open Start->Programs->SQLServer...->Configuration....->Surface Area Configuration, then click by Features link and enable 'Ad Hoc Distributed Queries'

Still getting same error after configuring

|||

Try this

EXEC sp_configure 'Ad Hoc Distributed Queries', '1';

RECONFIGURE;

|||

Hi try this........

Just copy the below stored procedure and run by passing the required parameter.

Stored Procedure:

create procedure sys.sp_addlinkedserver

@.server sysname, -- server name

@.srvproduct nvarchar(128) = NULL, -- product name (dflt to ss)

@.provider nvarchar(128) = NULL, -- oledb provider name

@.datasrc nvarchar(4000) = NULL, -- oledb datasource property

@.location nvarchar(4000) = NULL, -- oledb location property

@.provstr nvarchar(4000) = NULL, -- oledb provider-string property

@.catalog sysname = NULL -- oledb catalog property

as

-- VARIABLES

declare @.retcode int

-- VALIDATE OLEDB PARAMETERS

if @.provider is null

begin

-- NO PROVIDER MEANS CANNOT SPECIFY ANY PROPERTIES!

if @.datasrc is not null or @.location is not null or

@.provstr is not null or @.catalog is not null

begin

raiserror(15426,-1,-1)

return (1)

end

-- THIS MUST BE A WELL-KNOWN "SQL Server" TYPE (DEFAULT IS SS)

if @.srvproduct IS NOT null AND lower(@.srvproduct) <> N'sql server'

begin

raiserror(15427,-1,-1,@.srvproduct)

return (1)

end

-- USE ALL-NULLS FOR SQL-SERVER PROVIDER

select @.srvproduct = NULL

end

else if @.srvproduct in (N'SQL Server') -- WELL-KNOWN PRODUCT

begin

-- ILLEGAL TO SPECIFY PROVIDER/PROPERTIES FOR SQL Server PRODUCT

raiserror(15428,-1,-1,@.srvproduct)

return (1)

end

else if @.srvproduct is null or lower(@.srvproduct) like N'%sql server%'

begin

raiserror(15429,-1,-1,@.srvproduct)

return (1)

end

-- ADD THE LINKED-SERVER

EXEC @.retcode = sys.sp_MSaddserver_internal @.server,

@.srvproduct, @.provider, @.datasrc, @.location, @.provstr, @.catalog,

1, 0, 0 -- @.linkedstyle, @.localentry, @.dup_ok

return @.retcode

-- SUCCESS

return (0) -- sp_addlinkedserver

For Execution:

sys.sp_addlinkedserver 'XLTEST_SP','Excel','Microsoft.Jet.OLEDB.4.0',

'c:\sample.xls','Excel 8.0'

Just leave Location and Catalog

This will create a Linked Server name called XLTEST_SP.

Then do normal procedure!!!!!!!!!!!!!!!!!!!!!!!

how can i import file excel in SQL2005

how can i import data from excel file to SQL2005 to create new table or insert data from excel file to table. USING sql statement.
i want to use on C# , on C# i use what connect to control this action.
thanks alot.You could use OPENROWSET table value function for opening any OLEDB datasource:
--Create table XLImport and inserts data:
SELECT * INTO XLImport
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

--Insert data into existed table
INSERT INTO XLImport
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

Other approaches: http://support.microsoft.com/kb/321686|||Thanks for answer me;
But it return error :

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

i'm trying to connect using sql author.. but it return the same error;
help me, thanks alot|||Open Start->Programs->SQLServer...->Configuration....->Surface Area Configuration, then click by Features link and enable 'Ad Hoc Distributed Queries'|||

Konstantin Kosinsky wrote:

Open Start->Programs->SQLServer...->Configuration....->Surface Area Configuration, then click by Features link and enable 'Ad Hoc Distributed Queries'

Still getting same error after configuring

|||

Try this

EXEC sp_configure 'Ad Hoc Distributed Queries', '1';

RECONFIGURE;

|||

Hi try this........

Just copy the below stored procedure and run by passing the required parameter.

Stored Procedure:

create procedure sys.sp_addlinkedserver

@.server sysname, -- server name

@.srvproduct nvarchar(128) = NULL, -- product name (dflt to ss)

@.provider nvarchar(128) = NULL, -- oledb provider name

@.datasrc nvarchar(4000) = NULL, -- oledb datasource property

@.location nvarchar(4000) = NULL, -- oledb location property

@.provstr nvarchar(4000) = NULL, -- oledb provider-string property

@.catalog sysname = NULL -- oledb catalog property

as

-- VARIABLES

declare @.retcode int

-- VALIDATE OLEDB PARAMETERS

if @.provider is null

begin

-- NO PROVIDER MEANS CANNOT SPECIFY ANY PROPERTIES!

if @.datasrc is not null or @.location is not null or

@.provstr is not null or @.catalog is not null

begin

raiserror(15426,-1,-1)

return (1)

end

-- THIS MUST BE A WELL-KNOWN "SQL Server" TYPE (DEFAULT IS SS)

if @.srvproduct IS NOT null AND lower(@.srvproduct) <> N'sql server'

begin

raiserror(15427,-1,-1,@.srvproduct)

return (1)

end

-- USE ALL-NULLS FOR SQL-SERVER PROVIDER

select @.srvproduct = NULL

end

else if @.srvproduct in (N'SQL Server') -- WELL-KNOWN PRODUCT

begin

-- ILLEGAL TO SPECIFY PROVIDER/PROPERTIES FOR SQL Server PRODUCT

raiserror(15428,-1,-1,@.srvproduct)

return (1)

end

else if @.srvproduct is null or lower(@.srvproduct) like N'%sql server%'

begin

raiserror(15429,-1,-1,@.srvproduct)

return (1)

end

-- ADD THE LINKED-SERVER

EXEC @.retcode = sys.sp_MSaddserver_internal @.server,

@.srvproduct, @.provider, @.datasrc, @.location, @.provstr, @.catalog,

1, 0, 0 -- @.linkedstyle, @.localentry, @.dup_ok

return @.retcode

-- SUCCESS

return (0) -- sp_addlinkedserver

For Execution:

sys.sp_addlinkedserver 'XLTEST_SP','Excel','Microsoft.Jet.OLEDB.4.0',

'c:\sample.xls','Excel 8.0'

Just leave Location and Catalog

This will create a Linked Server name called XLTEST_SP.

Then do normal procedure!!!!!!!!!!!!!!!!!!!!!!!

how can i import file excel in SQL2005

how can i import data from excel file to SQL2005 to create new table or insert data from excel file to table. USING sql statement.
i want to use on C# , on C# i use what connect to control this action.
thanks alot.You could use OPENROWSET table value function for opening any OLEDB datasource:
--Create table XLImport and inserts data:
SELECT * INTO XLImport
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

--Insert data into existed table
INSERT INTO XLImport
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

Other approaches: http://support.microsoft.com/kb/321686|||Thanks for answer me;
But it return error :

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

i'm trying to connect using sql author.. but it return the same error;
help me, thanks alot|||Open Start->Programs->SQLServer...->Configuration....->Surface Area Configuration, then click by Features link and enable 'Ad Hoc Distributed Queries'|||

Konstantin Kosinsky wrote:

Open Start->Programs->SQLServer...->Configuration....->Surface Area Configuration, then click by Features link and enable 'Ad Hoc Distributed Queries'

Still getting same error after configuring

|||

Try this

EXEC sp_configure 'Ad Hoc Distributed Queries', '1';

RECONFIGURE;

|||

Hi try this........

Just copy the below stored procedure and run by passing the required parameter.

Stored Procedure:

create procedure sys.sp_addlinkedserver

@.server sysname, -- server name

@.srvproduct nvarchar(128) = NULL, -- product name (dflt to ss)

@.provider nvarchar(128) = NULL, -- oledb provider name

@.datasrc nvarchar(4000) = NULL, -- oledb datasource property

@.location nvarchar(4000) = NULL, -- oledb location property

@.provstr nvarchar(4000) = NULL, -- oledb provider-string property

@.catalog sysname = NULL -- oledb catalog property

as

-- VARIABLES

declare @.retcode int

-- VALIDATE OLEDB PARAMETERS

if @.provider is null

begin

-- NO PROVIDER MEANS CANNOT SPECIFY ANY PROPERTIES!

if @.datasrc is not null or @.location is not null or

@.provstr is not null or @.catalog is not null

begin

raiserror(15426,-1,-1)

return (1)

end

-- THIS MUST BE A WELL-KNOWN "SQL Server" TYPE (DEFAULT IS SS)

if @.srvproduct IS NOT null AND lower(@.srvproduct) <> N'sql server'

begin

raiserror(15427,-1,-1,@.srvproduct)

return (1)

end

-- USE ALL-NULLS FOR SQL-SERVER PROVIDER

select @.srvproduct = NULL

end

else if @.srvproduct in (N'SQL Server') -- WELL-KNOWN PRODUCT

begin

-- ILLEGAL TO SPECIFY PROVIDER/PROPERTIES FOR SQL Server PRODUCT

raiserror(15428,-1,-1,@.srvproduct)

return (1)

end

else if @.srvproduct is null or lower(@.srvproduct) like N'%sql server%'

begin

raiserror(15429,-1,-1,@.srvproduct)

return (1)

end

-- ADD THE LINKED-SERVER

EXEC @.retcode = sys.sp_MSaddserver_internal @.server,

@.srvproduct, @.provider, @.datasrc, @.location, @.provstr, @.catalog,

1, 0, 0 -- @.linkedstyle, @.localentry, @.dup_ok

return @.retcode

-- SUCCESS

return (0) -- sp_addlinkedserver

For Execution:

sys.sp_addlinkedserver 'XLTEST_SP','Excel','Microsoft.Jet.OLEDB.4.0',

'c:\sample.xls','Excel 8.0'

Just leave Location and Catalog

This will create a Linked Server name called XLTEST_SP.

Then do normal procedure!!!!!!!!!!!!!!!!!!!!!!!

How can I import data from Excel to SQL server 2005 Express

I would like to import an Excel file into my SQL Server 2005 Express db. I'm using SQL Server Management Studio Express to manage my db.

I appreciate your suggestions,

You need to use SQL server Business Intelligence Development studio and create SSIS package

Using simple Drag and Drop controls

|||

Sorry, I do not have these tools to work with.

|||

Ok, Right click on the Database then Task -> Import

select your Data source as Microsoft Excel file map the fields to destination click finish

How can I import CSV or Excel data into SQL2005 Express ?

How can I import CSV or Excel data into SQL2005 Express ?
Thanks.
You can run a query using BULK INSERT to import a CSV file:
BULK INSERT MyTable
FROM 'c:\data.csv'
WITH (FIELDTERMINATOR = ',',
ROWTERMINATOR ='\n')
And one way to import Excel sheet:
INSERT INTO MyTable
SELECT *
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\Test.xls;Extended Properties="Excel
8.0;IMEX=1"')...[Sheet1$];
HTH,
Plamen Ratchev
http://www.SQLStudio.com
|||I would only use this as a last resort - but depending on the spreadsheet
size , you can copy and paste via the Management Studio - assuming you have
the tables properly defined/mapped
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com
"Yips" <alvin@.yipschemical.com> wrote in message
news:OnpgVgGaIHA.4696@.TK2MSFTNGP05.phx.gbl...
> How can I import CSV or Excel data into SQL2005 Express ?
> Thanks.
>
|||It works. Thanks.
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:Psydnci4PfWI4zTaRVnyvwA@.bt.com...
>I would only use this as a last resort - but depending on the spreadsheet
>size , you can copy and paste via the Management Studio - assuming you have
>the tables properly defined/mapped
> --
> Jack Vamvas
> ___________________________________
> Search IT jobs from multiple sources- http://www.ITjobfeed.com
>
>
> "Yips" <alvin@.yipschemical.com> wrote in message
> news:OnpgVgGaIHA.4696@.TK2MSFTNGP05.phx.gbl...
>