question

Dong-6152 avatar image
0 Votes"
Dong-6152 asked BobJohnson-6874 edited

ACE OLEDB 12.0 Provider limited to read 255 columns of text file

ACE OLEDB 12.0 is excellent, whereas with two defaults: (1) limited to the first 255 columns of data file (text format); (2) the extended property 'FMT=Delimited' not working for tab-delimited text file. there are numerous postings about work-around, but just curious if Microsoft is aware the two defaults and planning to publish an upgrade version.

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers