Append an Access Database after using FileSystemOb
I just read the article, "Using the FileSystemObject to Read Text Files". How can I take the data that was read from the text file and append a table in a Microsoft Access database located on the webserver?<BR><BR><BR>
...in the text file and how's it's stored. If it's a CSV file, you could open a connection to the database, open the relevant table, read the file in line by line, split the fields up at the comma (not just using Split() though - it's a bit more complex than that), and then add a new record to the table as you go - one for each line in the CSV file.<BR><BR>Oliver.
The text file is outputted from a scantron program with the extension .txt and is comma delimited. The number of fields are always the same.<BR><BR>I am very new at this and I was wondering if there was some sample code that I could view that could show me how to accomplish this.