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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using INSERT INTO statement in Access 2003 VBA
the purpose for this code is to insert the data from the temporary table into the final destination table which has primary keys and foreign keys which are used to establish a relationship strTName is the final destination table the strTMP is the temporary table which holds the imported data...- vbavir
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using INSERT INTO statement in Access 2003 VBA
the code I am working on imports a txt file into a temporary table - the table names and fields change with each txt file that is imported - so I do not know what the field names will be or tables being used to import the data here is what I currently have for code Dim db As Database Dim rs As...- vbavir
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
VBA Access Code - Starting a new line in Excel export
I am very new to this forum stuff I have a VBA code which currently exports a set of 8 fields into Excel - the set consists of part number, quantity, total quantity, number of packs, pack quantity - for each dealer I only need a total of 8 sets - works great However some dealers have less than...- vbavir
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
