Hey guys,
I currently have a simple query with a parameter to allow the user to type in an item code and pull all of the information required, I then have a macro to export this data to Excel. What I would like to do is be able to enter multiple item codes at once so that I can export the...
Ah okay, I've just tested quickly with the Excel file and that had 0 problems exporting to txt. It's not a problem, I've decided to link the Excel export created from the external database to my current one and I have an append query to update the tables within my database. This seems to do the...
I don't think it has to be text, that's just what I tried first and was curious as to why that didn't work at all but Excel was perfectly fine. Just in case I encounter the problem again but do need it to be text.
Access is all very new to me so still getting to grips with it all.
Hey,
Thanks for answering. I haven't tried this since there are actually 8 external databases (currently separated for use by different parts of the business, this was setup before I joined the company). All of the databases give a similar output so I was going to mimic my query/macro once...
Hi Everyone,
So my issue currently is:
I would like to run a macro to call a query from a database that contains a lot of information I need for what I am doing (this separate database is owned by someone else and multiple people input data into it). I have setup a query in this separate...