ACC: Cannot Import Spreadsheet If Field Name Begins with Space

MORE INFORMATION

Steps to Reproduce Problem

1. Start Microsoft Excel and create the following spreadsheet. Type a space in front of the word "Cost":
   

         Item       <space>Cost       Quantity
         a                   25              2
         b                   23              8
   						

2. Save the file as C:\My Documents\TestSpace.xls, and then quit Microsoft Excel.
3. Start Microsoft Access and open the sample database Northwind.mdb.
4. On the File menu, point to Get External Data, and then click Import.
5. In the Import dialog box, select Microsoft Excel (*.xls) in the Files Of Type box, and then select TestSpace.xls. Click Import.
6. Click Next in the first dialog box of the Import Spreadsheet Wizard.
7. In the "Does the first row specified contain column headings?" dialog box, click "First Row Contains Column Headings," and then click Finish. Note that you receive the error message.
   
   To resolve the error, open TestSpace.xls in Microsoft Excel and remove the space in front of the word "Cost." Then repeat steps 2-7 and note that the error does not occur.