Importing Data to a Table and Appending to Another Table

[Hulamom]

Greetings All:

I have to import a file from an external website into a table (tableA) that I have established. The issue is that I don't need all that data, just specific ones (the website does not allow me to select the specific data to export). I created another table (tableB) to capture the data that I require for my report.

Q: How do I take raw data from tableA to append to tableB the required fields that I want?

 

[bob fitz]

What is your criteria for a required record to appear in tableB

 

[Hulamom]

Hi Bob:

My criteria is:
StartDate
EndDate
CustomeID (which is the link between the two tables)
ActivityDate
Name
ContactType

The original raw data is being pulled from an external website. I wanted to get the information that I need from that .csv file and import it into tableB.

I though the easiest was was the import the .csv file into the raw data table (which has 144 fields) and then have the table append to tableB the fields that I really need (which is 20 fields).

Am I going about this all wrong?

 

[bob fitz]

Hi Bob:

My criteria is:
StartDate
EndDate
CustomeID (which is the link between the two tables)
ActivityDate
Name
ContactType

The original raw data is being pulled from an external website. I wanted to get the information that I need from that .csv file and import it into tableB.

I though the easiest was was the import the .csv file into the raw data table (which has 144 fields) and then have the table append to tableB the fields that I really need (which is 20 fields).

Am I going about this all wrong?

Why not just create a query based on tableA but only include in it the required fields. You could then use that query as the data source for your report.