views:

15

answers:

1

Hello, I am using MSAccess and am using this code

[Text;HDR=''No'';FMT=''Delimited'';Database='+ExtractFilePath(Location)+'].'+ ExtractFileName(Location);

What are the different options I can use for FMT? I have seen:

  1. Fixed
  2. Delimited
  3. TabDelimited
A: 

The ODBC Text Driver supports the following formats:
Tab Delimited
CSV Delimited
Custom Delimited
Fixed-Length

RandomNoob