exporting data from access to excel with chosen order

[thread]

Hi all,
i'm trying to export access data form to excel,its placing the correct
data but the issue is that the fields are not orginized as i want,is
there a way to decide on the column from the start and to takeout
fields that we dont want and to decide on the oder that the fields will
be orginized via vb code?

 

[Albert D. Kallal]

Just build a query. A query lets you include only fields that you want, and
also lets you set the sort order.

You can even use format() function for date fields if you need something
special in that regards.

Then, just export the query...not the table....

 

[thread]

yes but for this i need to build around 40 queries,here i have modular
form that i just export it and thats it,data is changing between 1 to

 

[Albert D. Kallal]

yes but for this i need to build around 40 queries,here i have modular
form that i just export it and thats it,data is changing between 1 to
another

Sure, I mean, you going to have to write down somewhere (and somehow) as to
what fields you want. Who, how is anyone going to know exactly what FIELDS
you want?

Writing this information down in a query is as good as any place....

I actually never used the export feature function *on a form*. In fact, I
did not realize it actually works for a form (I guess that I why I
participate in this newsgroup!).

However, as mentioned, you need to write *somewhere* what fields you want
for a given form.

So, I would actually come up with a naming scheme, so, if my form was called

frmCustomers

Then, I would create a query call

qryfrmCustomersExport

(or, if you are changing/setting the forms reocrdsource, then base the query
name on that + some extension.

Then, for each form, I could create a button + code to export the current
form (using transfer text + the name of the form to figure out what query to
be used.

I don't know your level of coding skills, but as mentioned, you have to
SOMEWHERE define what fields of that form are to be included in the export,
and that is a bit of work that you can't avoided. I think the best place to
"write down" what fields for the form is to use a query.

 

[thread]

hi albert,
from what i know about programming globaly and access specific is that
for every hard problem there is an easy solution.
i will try to make some more research regarding this metter in order to
see what more option can i have
thanks
Albert D. Kallal כתב: