SQL Query a CSV File

Applies To: AutoMate 6, AutoMate 5
 

More Tutorials

Automate Complete Introduction 6/21/171956 views
The Automate Enterprise Ops Console Overview 5/17/171593 views
Getting Started With AutoMate 10 2/19/1510004 views
Getting Started With BPA Server 10 1/30/154912 views
How to Extract Information from Exchange 11/29/125470 views
How To AutoMate VMware 10/29/128165 views
How To AutoMate Amazon Web Services (AWS) 9/25/127341 views
How To AutoMate Email and SMS Notification 8/28/1211257 views
How To AutoMate PowerShell Scripts 7/31/1220300 views
How To AutoMate Web Services 7/5/127797 views
How To AutoMate Web Extraction 7/5/127606 views
Getting Started: BPA Server 9 2/24/128676 views
Getting Started With AutoMate 9 1/6/1221246 views
Overview of the BPA Server Management Console (SMC) 2/24/116487 views
Getting Started With BPA Server 8 2/16/116975 views
Getting Started With AutoMate 8 12/21/1017305 views
Interacting with a Drop-Down Menu 1/24/0820059 views
AutoMate BPA Server Agent Deployment 12/18/0715845 views
User Resource Center 10/16/0711056 views
Account Page 10/16/079426 views
AutoMate BPA Server 7 10/16/0726126 views
Looping and Sending Emails From a List 5/22/0713872 views
Looping With Excel 3/23/0722250 views
Terminal Emulation 2/20/0716853 views
Download File from Web 1/16/0719066 views
Web Account Login 11/20/0622277 views
SQL Query a CSV File 9/1/0630360 views
FTP Uploads by Files Last Modified Date 7/18/0617513 views
FTP Download by Date 6/1/0619140 views
The File Watcher and FTP Actions 3/14/0628341 views
AutoMate 6 Intro (Outdated, See "Getting Started With AutoMate 8") 3/13/0661554 views
 

Comments (6)

  1. 1/11/07 by Kris Smith
    Excellent! Exactly what i needed to do.
  2. 4/11/07 by Laura Genetti
    Good to know, but still too complicated for me...
  3. 3/24/14 by Anonymous
    Good tutorial. Just wondering for the CSV file if we can use a custom delimeter? For instance the pipe or semi-colon? Maybe include how to use custom delimiter into the tutorial.
  4. 3/24/14 by Leonard Amabile
    @anonymous - Custom delimiters are specified within the connection strings themselves. Please review the following page for more information:http://www.connectionstrings.com/textfile/
  5. 10/2/15 by Anonymous
    I keep getting the error of 'Parameter has no default value', what's up with this?
  6. 10/5/15 by Valentineo McGowan
    Hello Anonymous, Please feel free to either open a Support Ticket here: www.networkautomation.com/account OR submit the issue on our open Forums here: http://forums.networkautomation.com/forum/ and providing as much detailed information as possible. Thank you. We look forward to hearing from you.
Please sign in to your account or your comment will be forever stored under "anonymous".
Include Code Snippet

Search the URC

Subscribe to Version History via RSS
Subscribe to Version History via RSS
Version Watcher

11.0.2 changelog
11.0.2 changelog
other versions downloads

Contribute

Subscribe to Latest Resources via RSS
Subscribe to Latest Resources via RSS
Latest Resources

show filter options

Subscribe to Forum Posts via RSS
Subscribe to Forum Posts via RSS
Forum Posts