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