Ask Your Question
0

how to import, and set up fields and forms. [closed]

asked 2012-07-23 06:25:53 +0100

ShadoFyre gravatar image

updated 2013-02-22 10:03:48 +0100

qubit gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-02-27 18:57:18.047012

1 Answer

Sort by » oldest newest most voted
0

answered 2012-08-30 02:35:26 +0100

fred410 gravatar image

updated 2012-08-30 02:37:36 +0100

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.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-07-23 06:25:53 +0100

Seen: 335 times

Last updated: Feb 22 '13