<div>
But to be sure, check the *exact* definitions of these constants:<br />
&nbsp; &nbsp;acSpreadsheetTypeExcel9<br />
<br />
Do web search, or see the VBA Help files....
</div>


<div>
<div class="content wysiwyg-content">
I am working with an Access 2003 application using VBA code and I also am trying to import an Excel 2007 file with an extension of XLSX.<br />
<br />
My VBA code to import Excel files is as follows:<br />
<br />
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, &quot;Bank Credits (A)&quot;, filenm, False, &quot;Bank Credits (A)!A:N&quot;<br />
<br />
If I open the XLSX file and want to save it in Excel 2003 format so that I can import the file into my Access 2003 application, I notice that after I open the XLSX file, the file can be saved to file types as follows:<br />
<br />
Microsoft Office Excel Workbook (*.xls)<br />
Microsoft Office Excel 5.0/95 Workbook (*.xls)<br />
Microsoft Excel 97 Excel 2003 &amp;&nbsp;5.0/95 Workbook (*.xls)<br />
<br />
Which of these choices would you recommend? They all seem to work but I wanted advice on which choice is best.
</div>
</div>


I am working with an Access 2003 application using VBA code and I also am trying to import an Excel 2007 file with an extension of XLSX.

My VBA code to import Excel files is as follows:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Bank Credits (A)", filenm, False, "Bank Credits (A)!A:N"

If I open the XLSX file and want to save it in Excel 2003 format so that I can import the file into my Access 2003 application, I notice that after I open the XLSX file, the file can be saved to file types as follows:

Microsoft Office Excel Workbook (*.xls)
Microsoft Office Excel 5.0/95 Workbook (*.xls)
Microsoft Excel 97 Excel 2003 & 5.0/95 Workbook (*.xls)

Which of these choices would you recommend? They all seem to work but I wanted advice on which choice is best.

But to be sure, check the *exact* definitions of these constants:
   acSpreadsheetTypeExcel9

Do web search, or see the VBA Help files....

Which file type would you use to save an Excel 2007 xlsx as, when importing an Excel file into an Access 2003 database?

I am working with an Access 2003 application using VBA code and I also am trying to import an Excel 2007 file with an extension of XLSX.

My VBA code to import Excel files is as follows:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, &quot;Bank Credits (A)&quot;, filenm, False, &quot;Bank Credits (A)!A:N&quot;

If I open the XLSX file and want to save it in Excel 2003 format so that I can import the file into my Access 2003 application, I notice that after I open the XLSX file, the file can be saved to file types as follows:

Microsoft Office Excel Workbook (*.xls)
Microsoft Office Excel 5.0/95 Workbook (*.xls)
Microsoft Excel 97 Excel 2003 &amp; 5.0/95 Workbook (*.xls)

Which of these choices would you recommend? They all seem to work but I wanted advice on which choice is best.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.