Access 2007: zunanji podatki txt

Gasperix

unread,

Jul 28, 2008, 7:50:00 AM7/28/08

to

V Accessu 2007 imam narejen (delujoč) import z linkom na txt file
Izvoz_partnerji2, nato pa make-table query X, ki celoten izvorni file
prekopira v tabelo Partnerji:

SELECT Izvoz_partnerji2.* INTO Partnerji
FROM Izvoz_partnerji2;

Problem je v tem, da (pri nespremenjeni txt datoteki!!) query X včasih
deluje, včasih pa javi:

Sprememb ni mogoče zapisati, ker vnesena vrednost krši nastavitve, določene
za to tabelo ali seznam (vrednost je na primer manjša od najmanjše vrednosti
ali večja od največje vrednosti). Popravite napako in poskusite znova.

Oz. napaka:
Numeric field overflow. (Error 3349)
The data in a Btrieve field is too large to represent in your application.

Ugotovil sem, da ČE SPREMENIM IME QUERYJA, query deluje 1x, nato pa spet
začne javljati zgornjo napako. Če ime ponovno spremenim, spet deluje (ampak
le 1x).
Ker bi rad ta proces avtomatiziral, me seveda tako delovanje/nedelovanje
moti in prosim za pomoč.

lp

Gasperix

unread,

Jul 28, 2008, 10:44:46 AM7/28/08

to

Sem že rešil, hvala. lp

dumi

unread,

Oct 1, 2008, 11:59:02 AM10/1/08

to

ali bi prosim lahko napisal kaj si moral narediti , da si odpravil to
ne-delovanje
--
uporabnik

Gasperix

unread,

Nov 13, 2008, 10:05:01 AM11/13/08

to

Hm, sem prišel na eno idejo in pregledal txt podatke in ugotovil, kaj je
krivo...

V enem stolpcu txt datoteke imam skoraj povsod številčne vrednosti, le v
parih primerih pa text (šifra države) - tega prej nisem vedel.

Ker Access očitno avtomatsko za ta stolpec določi številčni tip polja, noče
požreti texta. Iz neznanega razloga to deluje tako, kot sem opisal - sem
stestiral in problematične vrstice ročno odstranil iz txt fajla...

Hvala za pomoč. lp

greeneyed_itgirl

unread,

Dec 9, 2008, 12:02:04 PM12/9/08

to

I'm having the same error "The data in a Btrieve field is too large to
represent in your application." in Access 2007 when importing data from an
Excel spreadsheet into Access. Worked great in 2003.

I'd love to read this post ~but can't figure out what language it is in to
translate.

Any help/ideas would be great ~in English :)

Thanks, Nancy

Matija Hrovat

unread,

Dec 10, 2008, 1:29:59 AM12/10/08

to

Slovenian.
http://translate.google.com/translate?hl=sl&ie=UTF-8&u=http%3A%2F%2Fgroups.google.com%2Fgroup%2Fmicrosoft.public.si.office%2Fbrowse_thread%2Fthread%2F1e758ec0390385d3%3Fhl%3Dsl%26q%3D%2522btrieve%2Bfield%2Bis%2Btoo%2Blarge%2Bto%2Brepresent%2Bin%2Byour%2Bapplication%2522&sl=sl&tl=en&history_state0=

http://tinyurl.com/67ww7r
(It's almost readable :))

Besically it was solved by removing text values from column that contained
mostly numbers.
Take a look at the following article:
http://support.microsoft.com/kb/815277

Hope this helps.
Regards,
Matija

"greeneyed_itgirl" <greeneye...@discussions.microsoft.com> wrote in
message news:9A66BBC1-FE85-49F2...@microsoft.com...

> I'm having the same error "The data in a Btrieve field is too large to
> represent in your application." in Access 2007 when importing data from an
> Excel spreadsheet into Access. Worked great in 2003.
>
> I'd love to read this post ~but can't figure out what language it is in to
> translate.
>
> Any help/ideas would be great ~in English :)
>
> Thanks, Nancy
>
>
>
> "Gasperix" wrote:
>
>> V Accessu 2007 imam narejen (delujoč) import z linkom na txt file
>> Izvoz_partnerji2, nato pa make-table query X, ki celoten izvorni file
>> prekopira v tabelo Partnerji:
>>
>> SELECT Izvoz_partnerji2.* INTO Partnerji
>> FROM Izvoz_partnerji2;
>>
>> Problem je v tem, da (pri nespremenjeni txt datoteki!!) query X včasih
>> deluje, včasih pa javi:
>>

>> Sprememb ni mogoče zapisati, ker vnesena vrednost krąi nastavitve,
>> določene
>> za to tabelo ali seznam (vrednost je na primer manjąa od najmanjąe