Pull info from file into Sql Table automatically

I am real new to SQL. I need to find out how if possible- a way to pull info
from a csv file into a table in SQL automatically.
Can anyone tell me if this is or not possible. If it is possible could you
also direct me to where I could find the information as to how to do it.
Thanks in advance for any help.
DebbieDebbie,
It is very easy in MS SQL to import data from cvs file into SQL table. I
assume you are on MSSQL 2000. If you have created a table in MS SQL where
you wan to import data, right click on the table in EM (Enterprise Manager)
and click on All Tasks Import Data and then the first screen is the source.
Select Text File and the file name and in the next screen you can select the
destination table which can be already existing table or new table. Go
through the screens and now you have imported the data successfully into SQL.
Regards
"dcournoyer" wrote:
> I am real new to SQL. I need to find out how if possible- a way to pull info
> from a csv file into a table in SQL automatically.
> Can anyone tell me if this is or not possible. If it is possible could you
> also direct me to where I could find the information as to how to do it.
> Thanks in advance for any help.
> Debbie|||Am I able to set this to automatically pull at certain times throughout the
day or would I have to do it manually?
Debbie
"MrReportingSvcs" wrote:
> Debbie,
> It is very easy in MS SQL to import data from cvs file into SQL table. I
> assume you are on MSSQL 2000. If you have created a table in MS SQL where
> you wan to import data, right click on the table in EM (Enterprise Manager)
> and click on All Tasks Import Data and then the first screen is the source.
> Select Text File and the file name and in the next screen you can select the
> destination table which can be already existing table or new table. Go
> through the screens and now you have imported the data successfully into SQL.
> Regards
> "dcournoyer" wrote:
> > I am real new to SQL. I need to find out how if possible- a way to pull info
> > from a csv file into a table in SQL automatically.
> >
> > Can anyone tell me if this is or not possible. If it is possible could you
> > also direct me to where I could find the information as to how to do it.
> >
> > Thanks in advance for any help.
> >
> > Debbie|||You can do as "MrReportingSvcs" described and set the schedule.
"dcournoyer" wrote:
> Am I able to set this to automatically pull at certain times throughout the
> day or would I have to do it manually?
> Debbie
> "MrReportingSvcs" wrote:
> > Debbie,
> > It is very easy in MS SQL to import data from cvs file into SQL table. I
> > assume you are on MSSQL 2000. If you have created a table in MS SQL where
> > you wan to import data, right click on the table in EM (Enterprise Manager)
> > and click on All Tasks Import Data and then the first screen is the source.
> > Select Text File and the file name and in the next screen you can select the
> > destination table which can be already existing table or new table. Go
> > through the screens and now you have imported the data successfully into SQL.
> > Regards
> >
> > "dcournoyer" wrote:
> >
> > > I am real new to SQL. I need to find out how if possible- a way to pull info
> > > from a csv file into a table in SQL automatically.
> > >
> > > Can anyone tell me if this is or not possible. If it is possible could you
> > > also direct me to where I could find the information as to how to do it.
> > >
> > > Thanks in advance for any help.
> > >
> > > Debbie

PULL huge table from SQL Server Problem

Hey Guys

I have meet the same problem, too.

I create a table with 1,380,000 rows data,

the db real size about 114 MB.

The primary key size is nchar(6).

When I use RDA pull, I found that the primary

key in the PDA disappear. So, It took a long time

to get query response.

But when I delete some rows to 680,000 rows of data.

After I pull, The primary key can pull from the SQL Server.

PS: I didn't change any code. Just delete some rows.

Is that SQL-Mobile's bug?

PS: 1.Database and Temp Database limitation both are 384MB

2.If I use query analyzer to add primary key it works! so strange!!

3.Pull process return "S_OK".

4.After Pull process finished, the db connection still alive. It seems not like

time out problem.

5.Local Connection String:"Data Source='%s\\%s';SSCEatabase Password='%s';SSCE:Encrypt Database='true';SSCE:Max Database Size=384;SSCE:Temp File Max size=384;SSCE:Temp File Directory=%s"

We do have tests that do PULL of 200 MB data and almost 10 Lakh rows. Is that possible for you to give the schema and few more details of your environment so that we can try reproducing and find the root cause.

Thanks,

Laxmi