Thanks hilbertl you got me on the right track. This is what I did
Dim path As String
Dim FileName As String
Dim file As String
path = "P:\my Documents\test\"
FileName = Dir(path + "*.*")
Do Until FileName = ""
Name path + FileName As path +...
Hi everybody,
My boss asked my to create an automated procedure to link about 200 Excel workbooks all the same form into one Access table. The workbooks are all in the same Directory.
I started with same code but I can't get it done.
DirName = "P:\My Documents\test\"
FileName =...
When I run the query it doesn't include all records from the tblVehicleSegment only those which are mached with tblTargetVehicle. What do I have to do to get all records from tblVehicleSegment? Thanks for you help.
SELECT tblVehicleSegment.SEGMENT, tblVehicleSegment.VEHICLE_CODE...
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.