"Bad file or number"

I suspect somehow this file was not properly terminated (eg ctl-z).
it is 5.5 GB and I'm trying to load it into Access. It responds too quickly
to have tried to read the file and found out it was too big.

I am thinking someway to copy binary and add a ^Z file?

It's been 2 decades since i did something like this and I suspect
whatever worked then won't work with 5.5 GB



- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

From:

I suspect somehow this file was not properly terminated (eg ctl-z).
it is 5.5 GB and I'm trying to load it into Access. It responds too
quickly
to have tried to read the file and found out it was too big.

I am thinking someway to copy binary and add a ^Z file?

It's been 2 decades since i did something like this and I suspect
whatever worked then won't work with 5.5 GB


32bit MS Access or 64bit MS Access ?


--
Dave
Multi-AV Scanning Tool - http://multi-av.thespykiller.co.uk
http://www.pctipp.ch/downloads/dl/35905.asp

On 01/23/2014 02:36 PM, wrote:
I suspect somehow this file was not properly terminated (eg ctl-z).
it is 5.5 GB and I'm trying to load it into Access. It responds too quickly
to have tried to read the file and found out it was too big.

I am thinking someway to copy binary and add a ^Z file?

It's been 2 decades since i did something like this and I suspect
whatever worked then won't work with 5.5 GB




I seriously doubt you were working with 5.5GB files 20 years ago

*+-
*+- It's been 2 decades since i did something like this and I suspect
*+- whatever worked then won't work with 5.5 GB


*+-I seriously doubt you were working with 5.5GB files 20 years ago

Isn't it obvious from the way I said it?


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

*+-I seriously doubt you were working with 5.5GB files 20 years ago

Isn't it obvious from the way I said it?

Not really.

If its a file from 20 years back (one possible way to read your statement) I
also doubt it. 20 years back (1994, a pre Windows time) even big *drives*
where measured in MB, not GB. And you would have had a quite special
program to work with filesizes at least three times the processors
address-bus width. Heck, even recently (on Fat32) filesizes where limited
to 2 GB.

Taking the other way to read it and assume you just now created/got a
datafile of 5.5 GB you can't read, what makes you think its the ctrl-Z thats
doing it ? It might very well be the (old) program itself not being able
to coope with a file over 2 GB in size ...

I am thinking someway to copy binary and add a ^Z file?

Type "copy /?" for full info. Create a file with a ctrl-Z (type ALT 26 if
I'm not mistaken) in it and use the "/b" option to "+" the files together
(to a new one) :

copy /b Srcfile1 /b Srcfile2 Trgfile

Hope that helps.

Regards,
Rudy Wieser


-- Origional message:
schreef in berichtnieuws
...
*+-
*+- It's been 2 decades since i did something like this and I suspect
*+- whatever worked then won't work with 5.5 GB


*+-I seriously doubt you were working with 5.5GB files 20 years ago

Isn't it obvious from the way I said it?


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus,
BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime
Bimbos]

On 01/24/2014 01:56 AM, wrote:
*+-
*+- It's been 2 decades since i did something like this and I suspect
*+- whatever worked then won't work with 5.5 GB


*+-I seriously doubt you were working with 5.5GB files 20 years ago

Isn't it obvious from the way I said it?




Sorry about that. I re-read what you posted and realized the mistake was
on my end ...however I don't believe "Access" can work with a data base
of that size. (2GB limit I believe)
How was it created?



http://office.microsoft.com/en-us/ac...010341462.aspx

Sure. (forgive noisy line)

2GB is mdb (out) limit not csv (in) limit

me hopes
but the bad file error comes
up too fast

ok.. gotta log off-- noise is driving me bats

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

On 01/24/2014 08:18 PM, wrote:
Sure. (forgive noisy line)

2GB is mdb (out) limit not csv (in) limit

me hopes
but the bad file error comes
up too fast



A csv is a text file, there is (essentially) no way that it could
legitimately be 5GB



Since you did not answer my question "how was it created"

no way can I help you further.

Someone in the NT batch newsgroup suggestes:

copy x.csv+nul /a

for which I am most gratefule

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

vjp2,

Someone in the NT batch newsgroup suggestes:

copy x.csv+nul /a

for which I am most gratefule

Nice, appending an "empty file" and depending on the "/a" switch to have the
copy command append a ctrl-z.

One drawback though : If, for whatever reason whatsoever, the CSV contains a
ctrl-z somewhere in the middle you will throw the remainder of the file
away. In other words: check the size of the result. If it apears to be
shorter than the origional something has gone wrong ...

But now the important question: Did adding that ctrl-z actually solve the
problem ? You did not mention anything about it.

Regards,
Rudy Wieser


-- Origional message:
schreef in berichtnieuws
...
Someone in the NT batch newsgroup suggestes:

copy x.csv+nul /a

for which I am most gratefule

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus,
BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime
Bimbos]

*+-One drawback though : If, for whatever reason whatsoever, the CSV contains a
*+-ctrl-z somewhere in the middle you will throw the remainder of the file

I'm up to my waist in alligators..
but I did another looksee and saw the disk I thought damaged
was the same size and some unzip programs think the file is corrupt and won't
open it and others will only give me half the file.

One other clue, GNU tail won't work, but on the full-sized file, grep finds
everything.


Which unzipper do you prefer? (the XP one is from 2008)


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

vjp2,

and saw the disk I thought damaged was the same size and
some unzip programs think the file is corrupt and won't open
it and others will only give me half the file.

Jup, sounds like a damaged disk / zipfile, and which than resulted in a
partial extraction of the datafile itself. And I must say I'm surprised
that you did get anything at all.

Which unzipper do you prefer? (the XP one is from 2008)

I do not have a preference, I just use whatever works. I can choose outof
several versions (most of them console based), and if needed even try some
generic product like WinRar, WinZip and alike.

But, when its really the disk (and thereby the zipfile) itself that is
damaged than you have little chance to repair it. Disk damage most always
goes in multiples of 512 bytes (one sectors worth of data), and thats a bit
much for a CRC (or alike) to fix ....

Regards,
Rudy Wieser


-- Origional message:
schreef in berichtnieuws
...
*+-One drawback though : If, for whatever reason whatsoever, the CSV
contains a
*+-ctrl-z somewhere in the middle you will throw the remainder of the file

I'm up to my waist in alligators..
but I did another looksee and saw the disk I thought damaged
was the same size and some unzip programs think the file is corrupt and
won't
open it and others will only give me half the file.

One other clue, GNU tail won't work, but on the full-sized file, grep
finds
everything.


Which unzipper do you prefer? (the XP one is from 2008)


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus,
BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime
Bimbos]

a