SQL Bulk Insert

Search the GP Tables

Search by TABLE NAME

Search by FIELD NAME

These are our PP (Def Revenue) scripts. All of our scripts for Dynamics GP can be found here

	PP (Def Revenue) Scripts
	No records to display.

stevegray
4Penny.net
Points: 56009
8/31/2020 9:10:35 AM

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Came across a requirement today to import a csv file into SQL. As usual, I want the quickest way to do this.

The text file looks like this (notice the inconsistent quotes):

1,"steve",123

2,tom,456

3,"jerry",789

Details below

Version: All

Section: SQL Scripts

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables

DynDeveloper.com