with the OPENROWSET example, how does ('Microsoft.Jet.OLEDB.4.0','text;HDR=NO;FMT=FixedLength;Database=g:\', test#txt) define the selection of text strings ?...

very well presented demo !...

BULK INSERT is used to insert data to a table from a text file. Only problem with it is that it is not possible to specify the columns that you want data to be imported. For example the table has 4 columns whereas there are data for 2 columns in the tex...

Thank you !!...

Geez ! I have been living under another myth ! What if there were 28 columns and varied structure ? Still no differentials ? And I have trusted all thsi "wisdom" for sooo many years.. Rick ...