Microsoft KB Archive/166352: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 88: | Line 88: | ||
# On the Data menu, point to Get External Data, and then click Create New Query. | # On the Data menu, point to Get External Data, and then click Create New Query. | ||
# Select your data source and click OK. | # Select your data source and click OK. | ||
# Add a few fields from the Customers table to | # Add a few fields from the Customers table to "Columns in your query," and then click Next 3 times. | ||
# Click | # Click "Return Data to Microsoft Excel" to select it, and then click Finish. | ||
# In | # In "Returning External Data to Microsoft Excel", accept the default Existing Worksheet, and then click OK. | ||
# Save the workbook as Book1. | # Save the workbook as Book1. | ||
# On the Data menu, click MS Access Form and click OK. Note that you receive the error message mentioned in the | # On the Data menu, click MS Access Form and click OK. Note that you receive the error message mentioned in the "Symptoms" section.<br /> | ||
<br /> | <br /> | ||
NOTE: If the MS Access Form command does not appear on the Data menu, run Setup to install the AccessLinks add-in. | NOTE: If the MS Access Form command does not appear on the Data menu, run Setup to install the AccessLinks add-in. | ||
Line 102: | Line 102: | ||
== REFERENCES == | == REFERENCES == | ||
For more information about the AccessLinks feature in Microsoft Excel, search the Microsoft Excel Help Index for | For more information about the AccessLinks feature in Microsoft Excel, search the Microsoft Excel Help Index for "AccessLinks add-in," and then "Convert a Microsoft Excel list to a Microsoft Access database." | ||
</div> | </div> |
Latest revision as of 10:03, 21 July 2020
Article ID: 166352
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q166352
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you try to create a Microsoft Access form in Microsoft Excel by using the AccessLinks add-in program, and you are using data from a Microsoft Query data source, you may receive the following error message:
CAUSE
You cannot use external data with the AccessLinks add-in.
RESOLUTION
When you create Microsoft Access forms in Microsoft Excel by using the AccessLinks add-in program, use only internal data for your data source.
MORE INFORMATION
Steps to Reproduce Behavior
- In Control Panel, create an ODBC data source to the Northwind database.
- Open Microsoft Excel and be sure Microsoft Query has been installed.
NOTE: If you have installed Microsoft Excel from Microsoft Office 97 Professional Edition, you will need to choose the Data Access option to install Microsoft Query.
- On the Data menu, point to Get External Data, and then click Create New Query.
- Select your data source and click OK.
- Add a few fields from the Customers table to "Columns in your query," and then click Next 3 times.
- Click "Return Data to Microsoft Excel" to select it, and then click Finish.
- In "Returning External Data to Microsoft Excel", accept the default Existing Worksheet, and then click OK.
- Save the workbook as Book1.
- On the Data menu, click MS Access Form and click OK. Note that you receive the error message mentioned in the "Symptoms" section.
NOTE: If the MS Access Form command does not appear on the Data menu, run Setup to install the AccessLinks add-in.
REFERENCES
For more information about the AccessLinks feature in Microsoft Excel, search the Microsoft Excel Help Index for "AccessLinks add-in," and then "Convert a Microsoft Excel list to a Microsoft Access database."
Keywords: kberrmsg kbprb KB166352