Hi,
I am fairly new to using VBA in Excel to carry out actions in Access (ADO). I have found a piece of code online to create a DB and then create a standard table.
I want to create a table that is linked to a excel spreadsheet. The code to do this (taken from Access module) is...
Hi,
Just as a point of interest as there have been a few posts on Concatenate recently. I tend to use "&" rather than the concatenate formula. eg:
="Hello"&" everybody"
instead of
=CONCATENATE("Hello"," everybody")
I haven't come across any issues using it and it seems to work in the...