First time here? Check out the FAQ!
asked 2012-07-23 06:25:53 +0200ShadoFyre
Have 86000+ lines in txt file to export to database. need help with that and setting up the fields,forms, &c. Please. Fields are:
Filename+ext, extension, Filesize, FileDate, FileTime, FileLoc, Cnt
A 'live' example:
J_#0_SetI_Wryt_MyWriting0_AllWrit001_Myn-Sp-Wr.zip;.zip;80,785;7/20/2012; 1:35:30 PM; [J:\#0\SetI_Wryt\MyWriting0\AllWrit001\];Count=8;
Please be sure to include what you're sending in the subject line,
No executables please.
maybe this will help (or maybe not) I had to import an "xls" file (one sheet) into database (essentially a single table DB, so it worked well)
1) created a new DB 2) opened "xls" file, selected and copied the headers and all the lines I wanted to import 3) in the database program, i left click on the "table" icon (to select that i was in correct place) 4) down in the lowere frame "Tables" - do a "right click" - select "paste" 5) then brings up the "import" dialog. 5b) theres an option there to use field names from first line (was handy)
that might give you some ideas...
forgot: you MUST allow the import dialog to create an index field, or else the new DB will be read-only.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-23 06:25:53 +0200
Seen: 77 times
Last updated: Feb 22