StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5198365
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-03-04T19:32:18.853
FavoriteCount
0
LastActivityDate
2011-03-04T19:32:18.853
LastEditDate
LastEditorUserId
0
OwnerUserId
126278
ParentId
5137417
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
This is pretty easy, and there is no reason to thunk over into the Desktop Text ODBC Driver because Jet 4.0 has a Text Installable ISAM that can do the job. Examples: Append text to existing table, import text as new table. <pre><code>Private Sub cmdAppend_Click() Dim lngRows As Long conDB.Execute _ "INSERT INTO ExistingTable SELECT * " _ & "FROM [Import.txt] IN '" & App.Path & "' 'TEXT;'", _ lngRows, _ adCmdText Or adExecuteNoRecords MsgBox CStr(lngRows) & " rows appended to ExistingTable." End Sub Private Sub cmdImport_Click() Dim lngRows As Long conDB.Execute _ "SELECT * INTO NewTable " _ & "FROM [Import.txt] IN '" & App.Path & "' 'TEXT;'", _ lngRows, _ adCmdText Or adExecuteNoRecords MsgBox CStr(lngRows) & " rows imported as NewTable." End Sub </code></pre> The key to making this work is to have a file named <code>Schema.ini</code> in the same folder as the text file (in this case I'm just using the App.Path folder for demonstration): <pre><code>[Import.txt] Format = Delimited( ) TextDelimiter = none ColNameHeader = False MaxScanRows = 0 Col1="Code" Text Width 9 Col2="Sequence" Text Width 10 Col3="Type" Integer Width 1 </code></pre> Above I made up field names and data types, which in a real case would match those in your database. Be sure to note the single blank space between the parentheses which will be the delimiting character used. If you have several text files in the same folder to import just add additional INI sections to Schema.ini as needed. Your program could even write such a Schema.ini to the folder dynamically if required, inserting the necessary text file name, list of fields and their names, type, sizes, etc.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POhow to import txt file into access database using vb6
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USBob77
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POhow to import txt file into access database using vb6
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.