Building a query to export data to another table (diff. field name

[maura]

Is there a way to build a query that would export data in one database to
another database with different field names?

I am trying to export invoices from my db to Quickbooks and found a program,
Accessbooks Updater 4.0, that is suppose to do this, but I don't quite
understand how to get the information from my tables to their tables if the
field names are different. For example:

In my database the field ClientCode
would be equal to their customerRef_ListID

A query or does this need to be programmed?

Thanks, maura

 

[Klatuu]

You can do this with a query. What you need to do is use Calculated Fields
that correspond to the field names in the target table if you are using the
query builder. To use your expample:
customerRef_ListID: ClientCode

If you are writing the sQL it would be

SELECT ClientID As customerRef_ListID

 

[geebee]

hi,

Yes, it is possible. Here is an example:

SELECT tbl_name.city AS newcol1, tbl_name.num AS newcol2, tbl_name.num2 AS
newcol3
INTO tbl_new IN 'C:\foldername\subfoldername\destinationdatabase.mdb'
FROM tbl_name;

Hope this helps,
geebee