Adding constant value to import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing table into a child table through a macro. Import happens for each row in the parent table individually
 
Hi Rajesh,

I'm not sure I understand you. If I'm right, you need to link the table
rather than import it, then use an append query to put the data from the
linked table into the child table, using a calculated field (e.g.

KeyID: 99

) to generate the key value for this group of child records.
 
You must log in or register to reply here.

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

Similar Threads

Update master and child table 1
VBA - retrieve data on last create named range from previous inserted named range 0
Importing spreadsheet cells that have multiple values 1
How to export table from outlook into ms access table? 0
Export Access 2003 Report to Text or CSV 2
Things to know in import from Excel 1
Error Message - Importing Excel to Access 2003 2
Importing Text Files Into Access 1

Back
Top