Issues exporting to Fixed Width Text

I have an Access 2000 query I am trying to export to fixed width text
file to upload to another server via a web application. When I create
the file, Access is deleting any row where the the account number
starts with the number 4. The acct number is 10 characters and is
saved as a text, but this is happening if the data is text or a
number. It happens using VBA or a manual export.

I have never seen this before, any thoughts on what to check?

Brian

Brian wrote:

> I have an Access 2000 query I am trying to export to fixed width text
> file to upload to another server via a web application. When I create
> the file, Access is deleting any row where the the account number
> starts with the number 4. The acct number is 10 characters and is
> saved as a text, but this is happening if the data is text or a
> number. It happens using VBA or a manual export.
>
> I have never seen this before, any thoughts on what to check?
>
> Brian

Nope. Any filter? Any error? Any weird characters in those excluded rows?

No, that is why it is really weird. I think I am going to try it in a
new db build and see what happens. I can't make it duplicate from any
other DB.



On Aug 19, 9:04*pm, Salad <o...@vinegar.com> wrote:
> Brian wrote:
> > I have an Access 2000 query I am trying to export to fixed width text
> > file to upload to another server via a web application. *When I create
> > the file, Access is deleting any row where the the account number
> > starts with the number 4. *The acct number is 10 characters and is
> > saved as a text, but this is happening if the data is text or a
> > number. *It happens using VBA or a manual export.
>
> > I have never seen this before, any thoughts on what to check?
>
> > Brian
>
> Nope. *Any filter? *Any error? *Any weird characters in those excluded rows?

Brian wrote:

> No, that is why it is really weird. I think I am going to try it in a
> new db build and see what happens. I can't make it duplicate from any
> other DB.

Hopefully that will correct the prob.

> On Aug 19, 9:04 pm, Salad <o...@vinegar.com> wrote:
>
>>Brian wrote:
>>
>>>I have an Access 2000 query I am trying to export to fixed width text
>>>file to upload to another server via a web application. When I create
>>>the file, Access is deleting any row where the the account number
>>>starts with the number 4. The acct number is 10 characters and is
>>>saved as a text, but this is happening if the data is text or a
>>>number. It happens using VBA or a manual export.
>>
>>>I have never seen this before, any thoughts on what to check?
>>
>>>Brian
>>
>>Nope. Any filter? Any error? Any weird characters in those excluded rows?
>
>

On a (potentially-related?) note -- I'm exporting a query (7000 rows)
to a CSV file for a client. When I run the query I get different
(correct) values, and when I run the export some values are incorrect.

What's odd is they aren't extraordinarily incorrect -- just missing
digits beyond the first. Datatype in Access is a double (number with
double precision); the CSV file gets the first or second digit, and
loose the rest. This is a significant error. Occurs in almost 40% of
records, and seems to happen most often in the thousandths decimal
place (query outputs "0.037", text export of query outputs "0.03", but
query "0.0029" outputs as text "0.0029").

Haven't been able to rectify this so coded around it. Anybody find a
more elegant solution/function?


On Aug 19, 6:15*pm, Salad <o...@vinegar.com> wrote:
> Brian wrote:
> > No, that is why it is really weird. I think I am going to try it in a
> > new db build and see what happens. I can't make it duplicate from any
> > other DB.
>
> Hopefully that will correct the prob.
>
> > On Aug 19, 9:04 pm, Salad <o...@vinegar.com> wrote:
>
> >>Brian wrote:
>
> >>>I have an Access 2000 query I am trying toexportto fixed widthtext
> >>>file to upload to another server via a web application. *When I create
> >>>the file, Access is deleting any row where the the account number
> >>>starts with the number 4. *The acct number is 10 characters and is
> >>>saved as atext, but this is happening if the data istextor a
> >>>number. *It happens using VBA or a manualexport.
>
> >>>I have never seen this before, any thoughts on what to check?
>
> >>>Brian
>
> >>Nope. *Any filter? *Any error? *Any weird characters in those excluded rows?