Re: Exporting Table Data - Not all data is exported

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 09/09/04 

Date: Thu, 9 Sep 2004 01:03:00 -0700

Thanks John,
When I say the first 20 records I mean the entire export
is correct as far as order is concerned except the first
20 are missing. The entire output is fine except for these
20 records and they are no different to the rest.

I am just using ultra edit to view the file that is
exported.

Even in the export preview pane you get when exporting the
first 20 are missing it always starts at record 21.

I have migrated the table tro another database with the
same results.

It happens on multiple tables in different databases.

With importing there are noi irregularities as far as I
can see.

Here is a sample of the data records in the table you must
remove the quotes. I treat each line as a new record in
the table. This fdata goes on and on in the same format
for many client records.

"@FILENO|2001232"
"@DATE|04 September 2004"
"@TITLE|Mr"
"@INITIALS|J"
"@SURNAME|Citizen"
"@ADDRESS1|1 address Rd"
"@ADDRESS2|"
"@ADDRESS3|"
"@SUBURB|SOMEWHERE"
"@STATE|NSW"
"@POSTCODE|2000"

When I get a chance I will change it to tab separated to
see if the same results happen.
Thanks,
Steve.

>-----Original Message-----
>Hi Steve,
>
>This isn't normal, but it will take more information to
work out what's
>going on.
>
>When you say "the first 20 records", what order are they
in? What do
>they have in common that the rest don't have?
>
>What software are you using to view the exported text
file?
>
>Is it possible that the records are being exported, but
not in the order
>you expect?
>
>Does this just happen with one table, or with all tables?
With one
>database, or all?
>
>As far as importing goes, the kind of problem you
describe is most often
>due to irregularities in the structure of the text file
being imported
>(e.g. it doesn't match the import specification; there
are surplus or
>missing "text qualifier" characters, and so on. I've seen
one other
>mention of a problem with the pipe character as field
separator,
>however, so it's worth changing the file to tab-separated
and seeing
>whether that imports cleanly.
>
>
>
>On Tue, 7 Sep 2004 19:59:05 -0700, "Steve Vickers"
><anonymous@discussions.microsoft.com> wrote:
>
>>I have a table that has say 100 records in it. When I
use
>>the file/export menu command and export the table data
to
>>a text file it does not export the first 20 records.
>>
>>I am using Access Professional 2003 sp1.
>>
>>Furthermore...
>>I get similar results when using the docmd.TransferText
>>method to import data into the table. I even get fields
>>containing the wrong data. The text file is | delimited.
>>
>>Does anyone have any ideas?
>>Is this an application bug?
>>Steve.
>
>--
>John Nurick [Microsoft Access MVP]
>
>Please respond in the newgroup and not by email.
>.
>

Relevant Pages

  • Re: Corrupt Mailbox Store
    ... transactions involved with the exporting and importing. ... The other question you had was why the database grew. ... > it cleared all of those excessive log files. ...
    (microsoft.public.exchange2000.information.store)
  • Re: Exporting Table Data - Not all data is exported
    ... Remember that a table in a relational database has no ... >Even in the export preview pane you get when exporting the ... >With importing there are noi irregularities as far as I ... >>Please respond in the newgroup and not by email. ...
    (microsoft.public.access.externaldata)
  • Re: Import from excel and add to table
    ... importing and exporting. ... This should answer most of your importing (and ... Dave Hargis, Microsoft Access MVP ... I would like to add the data to a table in my access database. ...
    (microsoft.public.access.externaldata)
  • Import incomplete - database may be damaged
    ... I back up my mail by exporting it to an archive and then importing it to Entourage on another Mac that I keep only as a backup. ... Start the Database Utility to verify your database. ...
    (microsoft.public.mac.office.entourage)
  • Re: Recurring items didnt import?
    ... all of my recurring items seem to be missing. ... Exporting and importing is guaranteed to lose data. ... folders to the new ones or just make the old PST the delivery location. ...
    (microsoft.public.outlook)