Hi
Brand new to this forum and Access so please go easy on me if my question seems stupid. Searching the forum doesn't bring up any results for me. Also, I hope I have posted in the most appropriate section of the forum and that the terms I am using are correct!
I have been using Access for about 10 days now on and off. I have used every other programme within the Microsoft suite over the years bar Access as I deemed I'd never have use for it. When I've tried it in the past, it's just been mind boggling so I've ended up shying away from it.
Anyway, I now have the bit between my teeth on a simple starter project (which actually isn't a simple starter project). I have been watching Kirt Kershaw's videos on YouTube so I already have a grasp of some basics. As usual, I am trying to run before I can walk.
I've created a database to contain stock from various sources and I ultimately want almost a one click solution to export revised quantities and prices into several different formats but, for now, one step at a time.
I have a field in a query with the name Action. The imported field name was "Action(SiteID=UK|Country=GB|Currency=GBP|Version= 585|CC=UTF-8)".
With this query, I want to be able to export it to CSV. For now, I can see I can only export to xlsx format which is fine. I can just go in and save it to CSV.
So my question is, actually, two-fold:-
a) When importing, is there some way using a macro or a VBA script to concatenate the "Action(SiteID=UK|Country=GB|Currency=GBP|Version= 585|CC=UTF-8)" simply down to Action and import all data to overwrite the previous data using a particular set field which wouldn't change (such as ItemID) and
b) When exporting, can I reverse the concatenation such that Action becomes Action(SiteID=UK|Country=GB|Currency=GBP|Version=5 85|CC=UTF-8).
One final point is I have also hidden fields in the query for legibility but I want those to be exported too (preferably without unhiding them). Simplicity is key.