Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Linking multipule workbooks in Excel to Access
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 +...- pat26
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Linking multipule workbooks in Excel to Access
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 =...- pat26
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Outer join
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...- pat26
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
