How to import data from a .csv file

I'm a SQL newbie and am wondering what is the correct procedure to
import data from .csv file into a SQL table. I want to electronically
clear checks in MS Dynamics GP and need to update one field in the
checks table to indicate that the check has cleared.
Any help is appreciated.
Best regards,
Frank Hamelly, MCP
NOVA Solutions LLC
Melbourne, FLfhamelly@.cfl.rr.com wrote:
> I'm a SQL newbie and am wondering what is the correct procedure to
> import data from .csv file into a SQL table. I want to electronically
> clear checks in MS Dynamics GP and need to update one field in the
> checks table to indicate that the check has cleared.
> Any help is appreciated.
> Best regards,
> Frank Hamelly, MCP
> NOVA Solutions LLC
> Melbourne, FL
>
Hi Frank,
You can do it either via DTS/SSIS (depending on which SQL server version
you are running) or you can create a linked server in SQL server and
then create a query that can select values from the file and then update
your tables.
Try to look for "importing data" in Books On Line - that should get you
started.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Thank you for the help Steen.
Frank