stupid qstion to ordering filed sin table (2000 sr 1)

Topic

New Reply

I use a VBA for Excel macro, to insert value from sheet to table into a mdb file…
is possible to ordering in alphabetical mode the fileds with a mcaro…?

have in table
aaa
cccc
bbb

i want in table
aaa
bbb
ccc

Reply | Quote

Replies

Why do you care about the order in the .mdb table? Whenever accessing that data you can specify a sort order for it, either by specifying an ORDER BY in the query that returns the recordset from the table, or dumping the whole table (in its existing order) into Excel and then sorting it in the s/sheet.

Reply | Quote

In the future, please ask Access questions in the Access forum.

(I agree with Dean, the order of fields in a table is irrelevant.)

Reply | Quote