AutoCollect - Creating User Defined DELTA Rowsets › Create a Sample Empty Excel Sheet › Import Data into Excel

Import Data into Excel

After you create a master spreadsheet, you can import data into it.

To import data into an Excel spreadsheet for MS-Excel 2003

1. Open the "empty" master spreadsheet saved earlier.
2. Save the spreadsheet with a new name.
3. Select BVM tab.
4. Click on cell A1.
5. Click on DATA > Import External Data > Import Data.

   A browse screen appears.

6. Use the browse screen to locate the BVM.txt file just downloaded and click on that file to import to the Excel worksheet.
7. Choose "Delimited", start input at row "1", then click NEXT.
8. Choose Delimiter as "semi-colon" (or whatever you used in the DSVOUT function), then click FINISH.
9. Select OK to insert at A1.
10. Repeat for each tab that you want to upload.

To import data into an Excel spreadsheet for MS-Excel 2007

1. Open the "empty" master spreadsheet saved earlier.
2. Save the spreadsheet with a new name.
3. Select BVM tab.
4. Click on cell A1.
5. Click on DATA > From text

   A browse screen appears.

6. Use the browse screen to locate the BVM.txt file just downloaded and click on that file to import to the Excel worksheet.
7. Choose "Delimited", start input at row "1", then click NEXT.
8. Choose Delimiter as "semi-colon" (or whatever you used in the DSVOUT function), then click FINISH.
9. Select OK to insert at A1.
10. Repeat for each tab that you want to upload.