Pref Method
"Hi what do you mean by diff formats?" What I mean by this is that the excel sheets have different formats in the columns. But they all should be text columns.
I would prefer to use method 2 as i have to do this for several lots of data.
What do i need to put in the module?
jean paul levahn
Last Activity: Nov 2 '10, 10:44 AM
Joined: Sep 3 '10
Location:
-
Appending 300 tables into 1 table
I need to append 300 tables (same columns, possible diff formats) onto 1 in Access.
All the tables start with the same name.
I used to have a piece of code that i ran that would simply pull all tables into 1 but have since lost it.
I have to be honest and say i have no VB skills what so ever and i think this is the only way this could be done quickly.
No activity results to display
Leave a comment: