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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Append Variable to Access Table
Hi Ed Code as follows simply inputs data and then rewrites it to another file - but I want to store each line in an Access table; Sub ReadInJ() Close Dim LineFromFile As String Dim x As Integer, y As Integer ReDim LineArray(0) As String IsFirstLine = 1 Open "C:\Documents and Settings\Alec\My...- Rainbow17
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Append Variable to Access Table
Hi Ed - Thanks for the interest. The code I have simply reads in the text file. I can write code to chop the data and put into arrays - stored as strings ready to be appended to my Access table(s). What I haven't been able to do is add code to store the strings in the table. As an eg I have a...- Rainbow17
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Append Variable to Access Table
Hi - I am a novice at Access and have what may be a basic problem. I have text files which I have imported in VB module and can manipulate to fit the fields of a table. What I can't do is append these variables to a table. How can I do this?- Rainbow17
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
