Name: How to config Excel for SQL queries
Uploaded: 2011-09-23T21:30:27+00:00
Duration: 5 min 51 s

How to config Excel for SQL queries

Sorry for the lack of audio, this was intended as a personal reference for myself and my team who were present for the demonstration. I'll create another, better one in the future.

For migration of data from PSFT to SFDC, we need to extract data from SQL Server in a CSV format. Then use Dataloader to import/upsert data to Salesforce.

CSV files are not the best solution, but here is an easy way to get data into Excel so that you can Save As.. a csv file that is ready to go into Dataloader.

If you write SQL in a way that you alias the result set with the same names as the fields in Salesforce, then Auto-Mapping is your friend.

Video Length: 05:51
Uploaded By: Jon Lal
Published: 9/23/2011
View Count: 60,956

Related Software Products

Excel-to-MSSQL

Published By:
Intelligent Converters

Description:
Excel-to-MSSQL is a program to migrate MS Excel data into MS SQL databases. Each worksheet becomes a table, each row becomes a record and each cell becomes a field. Key features: (1) all versions of MS Excel are supported; (2) converts individual worksheets; (3) merges MS Excel data into an existing MS SQL database; (4) converts Comma Separated Values (CSV) files into MS SQL tables; (5) stores conversion settings into profile; (6) command line support; (7) easy-to-use wizard style interface

MSSQL-to-Excel

Published By:
Intelligent Converters

Description:
MSSQL-to-Excel is a program to convert MS SQL databases into MS Excel spreadsheet. Key features: (1) all MS SQL data types are supported (2) fast conversion engine (20MB MS SQL database - in 1 minute on average P-III system) (3) converts individual tables (4) command line support (5) output spreadsheet is compatible with MS Excel 5.0 and higher (6) easy-to-use wizard style interface