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


G

Guest

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
 
Ad

Advertisements

G

Guest

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
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top