Prev: Truncation of text field in delimited linked file
Next: Criteria in Querry to include All and Empty Field
From: mike on 25 Feb 2010 15:19

From: alex on 25 Feb 2010 15:51
On Feb 25, 3:19 pm, mike <m...(a)discussions.microsoft.com> wrote:
>

Mike,

I suppose It depends on who you ask...since most databases are
relational, a flat file would take away this attribute, and resemble a
spreadsheet.

alex
From: Larry Linson on 25 Feb 2010 15:59
"mike" <mike(a)discussions.microsoft.com> wrote

Feel free to use the big white space under the subject line to make your
question clear.

A flat file is an unindexed file, usually either outside any database or
used as the (not very efficient) method of implementing a database. There's
no "flat file in Access". You could, if you wished, use an Access table as
though it were a flat file, but that would be neither wise nor efficient.

An Excel worksheet with all the information on the one worksheet (which
normally will lead to a lot of redundant information in the rows) is being
used as a "flat file", but Excel has capabilities that extend beyond the
"flat file" approach.

Larry Linson
Microsoft Office Access MVP



From: GP George on 25 Feb 2010 15:54
"Flat File" is a term many database folks use to refer to things like Excel
Worksheets (.csv format, for example), or text files (.txt format), and so
on. Sometimes it is used to refer to a single "table-like" structure such as
might be created by importing a Worksheet or text file into Access. "Flat"
refers to the fact that it is a nothing more than a single sheet, or table
with no relationships identified or defined.

A quick Bing or Google search should turn up some more detailed discussions
for you.

George

"mike" <mike(a)discussions.microsoft.com> wrote in message
news:225DD78E-289C-4186-BA86-03EF34E101CE(a)microsoft.com...
>
 | 
Pages: 1
Prev: Truncation of text field in delimited linked file
Next: Criteria in Querry to include All and Empty Field