Data
Data Integration with Jitterbit
Jitterbit is an amazing Open Source data & application integration suite. A Free Community Edition is available for download and use. Face it, manually importing and exporting Data between applications or databases in csv text files to keep data synchronized … Continue reading
Migrate MS Access to SQL Server Express 2005/2008
Considering that Microsoft has released Express Editions of MS SQL Server 2005 and 2008, I would hope that many people were encouraged to Migrate from using Access to MS SQL Express for their website or web application back end.
Using Excel Datasources
This article covers using MS Excel files as datasources and originally was geared towards ASP but applies to other programming languages. This article is also useful if you have problems with the import of Excel data into a database. U
Excel Spreedsheets SQL Table Names
There are 3 ways you can reference a table (or range) in an Excel workbook in your SQL Queries. Use the sheet name followed by a dollar sign (for example, [Sheet1$] or [My Worksheet$]). A worksheet table that is referenced … Continue reading
