Reading a large DBF

[JayWind]

I am reading
http://www.excelforum.com/showthread...hreadid=384823
the thread that began with
"I'd like your opinion/solution to break the limit of 65k lines in a XLS sheet."

May I ask your help?

My client gave me a 128K row DBF.
I don't have dBASE anymore, long gone.

I have ACCESS, but ACCESS can't import the data because the leftmost column does not contain a unique index. Any suggestions to read the DBF?


--
Thank you
Jay Jacob Wind

[FSt1]

hi,
I am afraid that you are stuck with the 65k line limit.
In xl help, type the word "specification". this will give you the limits of
excel.
as to importing into access, a unique key is not required. some databases
use unigue identifiers. example might be in an inventory database. two parts
cannot have the same part number so the part number would be the unique
identifier. but even a unique identifier is not reguired. unique
keys/identifiers are only required when your are searching, sorting or
linking to other tables/databases. without them, you could create yourself a
data management nightmare. but since your are dealing with a single table, i
see no great problem. I would import into access then try to split the table
to import to excel. without seeing your data, i can't say that it would work
but it is worth a try. back up your data before you try.

Good luck
FSt1

"JayWind" wrote:

>
> I am reading
> http://www.excelforum.com/showthread...hreadid=384823
> the thread that began with
> "I'd like your opinion/solution to break the limit of 65k lines in a
> XLS sheet."
>
> May I ask your help?
>
> My client gave me a 128K row DBF.
> I don't have dBASE anymore, long gone.
>
> I have ACCESS, but ACCESS can't import the data because the leftmost
> column does not contain a unique index. Any suggestions to read the
> DBF?
>
>
> --
> Thank you
> Jay Jacob Wind
>
>
> --
> JayWind
> ------------------------------------------------------------------------
> JayWind's Profile: http://www.excelforum.com/member.php...o&userid=35438
> View this thread: http://www.excelforum.com/showthread...hreadid=552112
>
>

[David Biddulph]

"FSt1" <FSt1@discussions.microsoft.com> wrote in message
news:6C25AEA1-0D60-4016-94BC-252F23412CAC@microsoft.com...
> hi,
> I am afraid that you are stuck with the 65k line limit.

.... unless you got to Excel 2007 beta. [But bear in mind the warnings about
the use of a beta.]
--
David Biddulph

[FSt1]

thanks for the reply. I am still stuck on xl xp. i will have to look into
2007 bata.

"David Biddulph" wrote:

> "FSt1" <FSt1@discussions.microsoft.com> wrote in message
> news:6C25AEA1-0D60-4016-94BC-252F23412CAC@microsoft.com...
> > hi,
> > I am afraid that you are stuck with the 65k line limit.
>
> .... unless you got to Excel 2007 beta. [But bear in mind the warnings about
> the use of a beta.]
> --
> David Biddulph
>
>
>