————————————————

January 28th, 2008 No comments Data export and format from MS Access & Sql Server to flat files for integration in to new system. I was provided with Data saved on USB Drive. This data was in MS Access File containing 90,000 rows. It was required to transformed the Data in a text file, which was simple, however challenging was the separation of customer Last Name and first Name in 1 field/Column to 2 separate columns. Moreover another column in which Data of products was separated by using left with a column leftmost characters of products, All of the data was scraped by using different Commands. I utilized the Access’s Export Wizard, by selecting option of ” select the appropriate delimiter and see how your text is effected in the preview below.

Data Import and Export