** Changing TEXT FILES to Access Tables **
-
Hi everyone, I need help with converting Text Files into Access table and hope you can help me out. I have 2 TEXT FILES, first that contains the table name, and its attribues, and the SECOND file contains the values of the table. So if the first TEXT FILE that has the following table values: tablename field1, integer field2, string field3, integer field4, string then another TEXT FILE will contains the values for the table: 1, john, 6, smith 2, steve, 7, clark 3, carrie, 8, wayne 4, dan, 9, chait 5, erin, 10, alan what i need to do is to read the values from the FIRST TEXT FILE that contains the table attributes and create the table. Then i need to read the SECOND TEXT FILE and plug in the values. so at the end, i'll have a Access table like: field1 field2 field3 field4 1 john 6 smith 2 steve 7 clark 3 carrie 8 wayne 4 dan 9 chait 5 erin 10 alan But i need the readings of BOTH TEXT FILES to be dynamic so it'll work if the TEXT FILE has x number of columns, and x number of rows. and i also need the reading to be dynamic so it can read the values from the SECOND TEXT FILE no matter what kind of values it contains, ie, integer, string, char, etc... If anyone can help me out, Please let me know. Thanks in Advance. Steve