.DAT files can be anything. If you can just use sqlite3.exe to open the .DAT and do proper queries on it (IE: sqlite3.exe yourfile.dat), then it's a proper SQLite3 database, so then you SHOULD be able to use the Attach command. Otherwise, you need to change the .DAT contents to something else that can be understood by IMPORT and OPEN.
On Mon, Apr 15, 2019 at 12:25 PM Pablo Boswell (US - ASR) < pablo.bosw...@pwc.com> wrote: > I am trying to use Command Line Interface (CLI) sqlite3.exe to import .DAT > files to an in-memory SQLite database. I cannot get the following commands > to load anything reasonable (the engine always decides to load the data as > a single TEXT column with a column name of "sqlite3 data"): > > - .ATTACH > - .IMPORT > - .OPEN > > What am I doing wrong? > > -- > *Pablo Boswell* > > ______________________________________________________________________ > The information transmitted, including any attachments, is intended only > for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited, and all liability arising therefrom is disclaimed. If you > received this in error, please contact the sender and delete the material > from any computer. PricewaterhouseCoopers LLP is a Delaware limited > liability partnership. This communication may come from > PricewaterhouseCoopers LLP or one of its subsidiaries. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
