• Apache Drill case study: A tutorial on processing CSV files

    Rob Terpilowski decided to take Apache Drill for a test drive and use it for processing CSV files. Here's a quick tutorial to show how you can do it to.

    ITKE440,630 pointsBadges:
  • comma-separated values file (CSV)

    In computers, a CSV (comma-separated values) file contains the values in a table as a series of ASCII text lines organized so that each column value is separated by a comma from the next column's value and each row starts a new line.

    ITKE440,630 pointsBadges:
  • Access logs in Excel format

    Obtain an Excel-readable, comma-delimited security logon/logoff/lockout log file (.csv) of a server.

    ITKE440,630 pointsBadges:
  • Using Jet OLEDB Provider for non CSVs text files

    Do you have any information on using the Jet OLEDB Provider for mapping onto other than comma separated values (CSVs) text files. There is no documentation on Microsoft's Web site. The extended properties include the FMT=Delimited name/value pair which leads me to wonder if there are other values...

    john111,730 pointsBadges:
  • Stored procedure: Simplify comma-separated value (CSV) exports

    Comma-separated value (CSV) exports are often used to provide SQL Server data to Excel -- but there is no simple way to export SQL Server data within a stored procedure to a file. The sp_SaveDelimitedColumns routine makes CSV exports a breeze by easily creating a file containing specific data.

    ITKE440,630 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.