These files include all published QCEW observations, including many which are not in the standard BLS database. We recognize that they are not easy to use. The QCEW program has developed several helper applications that can be used to import the flat files into common data manipulation applications such as Excel, Access, and SAS.
Instructions on how to open ENB files into Microsoft Excel
Unzip the excel file (makexls.xls) and open in Microsoft Excel
Select Tools from the menu bar at top.
Select Macro from menu, then select Macros
Select MAKEXLS and then hit the “Run” button
The macro will ask you click “OK” a couple of times
Then it will allow you to select the ENB file you want to open.
Another “OK” will appear-click it.
This will import the ENB data into excel. Be warned, though, that
Excel can only open 65,536 lines. Files longer than this should
be opened using our MS Access database tool, or your favorite database.
Instructions on how to open ENC files into Microsoft Excel
Unzip the excel file (makexls.xls) and open in Microsoft Excel
Select Tools from the menu bar at top.
Select Macro from menu, then select Macros
Select MakeENCXLS and then hit the “Run” button
The macro will ask you click “OK” a couple of times
Then it will allow you to select the ENC file you want to open.
Another “OK” will appear-click it.
This will import the ENC data into excel. Be warned, though, that
Excel can only open 65,536 lines. Files longer than this should
be opened using our MS Access database tool, or your favorite database.
Instructions on how to open END files into Microsoft Excel
Unzip the excel file (makexls.xls) and open in Microsoft Excel
Select Tools from the menu bar at top.
Select Macro from menu, then select Macros
Select MakeENDXLS and then hit the “Run” button
The macro will ask you click “OK” a couple of times
Then it will allow you to select the ENC file you want to open.
Another “OK” will appear-click it.
This will import the ENC data into excel. Be warned, though, that
Excel can only open 65,536 lines. Files longer than this should
be opened using our MS Access database tool, or your favorite database.
Instructions on how to import EN* files into Microsoft Access 97
Unzip the database (mkaccess97.mdb), then open it in Access.
Click on the “New” button on the right of the box on-screen.
Select import table and click “OK”.
Set file type to text files, and enter under file name *.en*
Select the data file you wish to import, then click “Import”.
This will start the import text wizard.
Click on “Advanced” at the bottom of the window
Click “Specs” on the right side.
Select the appropriate import specs (for example, “ENB Import Specification” for ENB files), click “Open”, then click “OK”.
Click “Finish” in the bottom of the window and the data will appear as a new table.
Instructions on how to import EN* files into Microsoft Access 2000/Access XP:
Unzip data file, change its file extension from ENB/ENC/END to TXT.
Unzip the database (mkaccessXP.mdb), then open it in Access.
Click on the “New” icon on the top line of the box on-screen.
Select import table and click “OK”.
Set file type to text files.
Select the file you wish to import, then click “Import”. This will start the import text wizard.
Click on “Advanced” at the bottom of the window
Click “Spec” on the right side.
Select the appropriate import specification. For example, for ENB files, select “ENB Import Specification”, click “Open”, then click “OK”.
10. Click “Finish” in the bottom of the window and the data will appear as a new table.
Click on the yes button below to take the survey after you have finished visiting our website. The survey will be available in the taskbar at the bottom of your screen when you are ready to take it.