I am trying to import data into Access from an Excel file. I continue to get "Numeric field overflow error 3349 - the data in a Btrieve file is too large to represent in your application."
I don't know what a Btrieve file is. I know if I open up the Excel file, resave it and close...
In the Macro, I can choose "OpenQuery", which runs the query I indicate in the boxes below. When I run a make table query, 2 message boxes pop up that ask me first if I want to delete the table that already exists and then if I want to create the new table with the number of fields...
I'm running a passthru query in Access, referencing a SQL database. In the passthru, is there any way to have the results end up in a table in Access instead of popping up on the display screen as a select query? Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.