Recent content by jnlw09

Thank you, David, for recognising my obvious frustration. I appreciate your generosity, and will let you know what happens. Cheers, .jnlw09.

Yes, David. That's about it. I don't have the start position, but that's easily overcome. I think you've answered my question, though, with the suggestion of Open..for input. This means I need to do the calculating and looping myself, instead of a structure like "IMPORT INTO.." etc. Ah...

Thanks, David. I actually have about 20 tables to import, and the problem is that the layouts of the tables may change from time to time. I have a database table of 'table names' and another table of data names for each table. From this I build the actual structure of each table. When this...

I'm stuck. All I want to do is import data from a fixed-length (fields are not delimited) text file into an MS Access database table. The table is already defined with names and field lengths. The Schema.ini file contains table name, the same field names and lengths as defined in the table. I...