appending query for "duplicate" tables

[Frustrated in AL]

I attempted to import information from an excel spread sheet to an existing
table that had all of the same type of information - I am receiving the
production information daily, so the dates are different but all of the
fields are the same.

When I was unable to add on to the existing table, I wound up creating 3
seperate tables. These tables have 11,880 records, 19,402 records, and
54,022 records.

1st question, is there a limit to how many records a table can hold?

I used the article on line "Adding rows by using an append query". I
selected my [Call tracking 2] and [Call tracking 3] as my source tables and
selected [Call tracking] as my destination table. All of this was set up in
the Design View.

When I try to run this query, I get an error message - Duplicate output
destination 'Date'. Date is one of the field names in all three tables. I
am, once again, confused.

I will attach the SQL for consideration. Any and all assistance is
appreciated.

INSERT INTO [Call Tracking]
SELECT [Call Tracking 2].*, [Call Tracking 3].*
FROM [Call Tracking 2], [Call Tracking 3];

 

[KARL DEWEY]

Try using two queries like this --
INSERT INTO [Call Tracking]
SELECT [Call Tracking 2].*
FROM [Call Tracking 2];

INSERT INTO [Call Tracking]
SELECT [Call Tracking 3].*
FROM [Call Tracking 3];

 

[Frustrated in AL]

Thank you Karl. Once again you have helped me out immensely.

Is there a limit to the number of records that a table can hold?

Try using two queries like this --
INSERT INTO [Call Tracking]
SELECT [Call Tracking 2].*
FROM [Call Tracking 2];

INSERT INTO [Call Tracking]
SELECT [Call Tracking 3].*
FROM [Call Tracking 3];

--
KARL DEWEY
Build a little - Test a little

I attempted to import information from an excel spread sheet to an existing
table that had all of the same type of information - I am receiving the
production information daily, so the dates are different but all of the
fields are the same.

When I was unable to add on to the existing table, I wound up creating 3
seperate tables. These tables have 11,880 records, 19,402 records, and
54,022 records.

1st question, is there a limit to how many records a table can hold?

I used the article on line "Adding rows by using an append query". I
selected my [Call tracking 2] and [Call tracking 3] as my source tables and
selected [Call tracking] as my destination table. All of this was set up in
the Design View.

When I try to run this query, I get an error message - Duplicate output
destination 'Date'. Date is one of the field names in all three tables. I
am, once again, confused.

I will attach the SQL for consideration. Any and all assistance is
appreciated.

INSERT INTO [Call Tracking]
SELECT [Call Tracking 2].*, [Call Tracking 3].*
FROM [Call Tracking 2], [Call Tracking 3];

 

[John Spencer]

There is always a limit. But in Access the number of rows is not the
limit. The amount of data is the limit.

A database can be up to 2 gigabytes in size. Therefore a table can hold
almost 2 gigabytes of data.


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Thank you Karl. Once again you have helped me out immensely.

Is there a limit to the number of records that a table can hold?

Try using two queries like this --
INSERT INTO [Call Tracking]
SELECT [Call Tracking 2].*
FROM [Call Tracking 2];

INSERT INTO [Call Tracking]
SELECT [Call Tracking 3].*
FROM [Call Tracking 3];

--
KARL DEWEY
Build a little - Test a little

I attempted to import information from an excel spread sheet to an existing
table that had all of the same type of information - I am receiving the
production information daily, so the dates are different but all of the
fields are the same.

When I was unable to add on to the existing table, I wound up creating 3
seperate tables. These tables have 11,880 records, 19,402 records, and
54,022 records.

1st question, is there a limit to how many records a table can hold?

I used the article on line "Adding rows by using an append query". I
selected my [Call tracking 2] and [Call tracking 3] as my source tables and
selected [Call tracking] as my destination table. All of this was set up in
the Design View.

When I try to run this query, I get an error message - Duplicate output
destination 'Date'. Date is one of the field names in all three tables. I
am, once again, confused.

I will attach the SQL for consideration. Any and all assistance is
appreciated.

INSERT INTO [Call Tracking]
SELECT [Call Tracking 2].*, [Call Tracking 3].*
FROM [Call Tracking 2], [Call Tracking 3];

 

[KARL DEWEY]

No. There is a 2GB limit to the database. Click on Help - About Microsoft
Access - System Info to learn more.
--
KARL DEWEY
Build a little - Test a little

Thank you Karl. Once again you have helped me out immensely.

Is there a limit to the number of records that a table can hold?

Try using two queries like this --
INSERT INTO [Call Tracking]
SELECT [Call Tracking 2].*
FROM [Call Tracking 2];

INSERT INTO [Call Tracking]
SELECT [Call Tracking 3].*
FROM [Call Tracking 3];

--
KARL DEWEY
Build a little - Test a little

I attempted to import information from an excel spread sheet to an existing
table that had all of the same type of information - I am receiving the
production information daily, so the dates are different but all of the
fields are the same.

When I was unable to add on to the existing table, I wound up creating 3
seperate tables. These tables have 11,880 records, 19,402 records, and
54,022 records.

1st question, is there a limit to how many records a table can hold?

I used the article on line "Adding rows by using an append query". I
selected my [Call tracking 2] and [Call tracking 3] as my source tables and
selected [Call tracking] as my destination table. All of this was set up in
the Design View.

When I try to run this query, I get an error message - Duplicate output
destination 'Date'. Date is one of the field names in all three tables. I
am, once again, confused.

I will attach the SQL for consideration. Any and all assistance is
appreciated.

INSERT INTO [Call Tracking]
SELECT [Call Tracking 2].*, [Call Tracking 3].*
FROM [Call Tracking 2], [Call Tracking 3];