Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 text file to sql server

Author  Topic 

Mohansoft
Starting Member

6 Posts

Posted - 2005-09-05 : 11:17:03
It is possible to make dts from access or excel.Can we transfer
the data from text files.

What are table spaces and blocks.

D.Mohan Raj

Kristen
Test

22859 Posts

Posted - 2005-09-05 : 15:24:29
"It is possible to make dts from access or excel.Can we transfer the data from text files."

Yes

"What are table spaces and blocks"

Now you've lost me. Can you re-phrase that please?

Kristen
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-06 : 00:39:55
>>Can we transfer
the data from text files.

Yes using Bulk Insert

>>What are table spaces and blocks.

You need to create a table to hold the data from text file

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -