iandevlin.com

Icon

A mixture of musings on web design & development, history, and life

Accessing data records from Excel and CSV files in VB.NET

vb.net

One of the first projects I undertook when I started at my current workplace was to produce a data migrator that ported user data records from a client system to one of our systems. This was written in VB.NET (for compatibility reasons) and the data sources were both Microsoft SQL Server 2005 systems. Recently I’ve had to make a few changes to it to allow the client data source to be either an Excel spreadsheet or a CSV text file. Having never worked with these methods before, I had to look it up (via Google of course) and thought I’d share with you the methods of doing this.

Read the rest of this entry »