I am trying to import records from a text file (which is located in a folder on our server) to an ACCESS database. My problem is that I have defined the specification file with delimiters between each field. The last field in the record is defined as a 'comment' with a data type memo. My problem is that when someone presses enter and continues to type in the comment field, it goes to the next line in the text file. When access tries to read the next record, the comment field is read as the next record. (positional) Access gives an error because the first field in a record is defined as a date field, so the record is not imported. Can Access or Visual Basic read a variable length file into an access database? Could someone give me an example if so?
Thank, jaggar
Thank, jaggar
