Link to home
Create AccountLog in
Avatar of Andy Donnelly
Andy DonnellyFlag for United States of America

asked on

Importing Excel into Access 2016

I'm using a macro in Access 2016 to import an excel file.  The user inputs the filename into a text box on a form and I need to pass that name to the field name the ImportExportSpreadsheet step in the macro.  It seems no matter how I format the name of the form/field it doesn't work.  I've tried [forms]![formname]![filename] but the macro says it can't find the file and generates a 2950 error.
Avatar of als315
als315
Flag of Russian Federation image

Can you upload sample with this macro?
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Andy Donnelly

ASKER

I was missing the = sign in the expression.  Looking at your screen shot solved my issue.

Thanks!