A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Reload this Page Must # of fields in the 2 tables in an Append Query be equal?
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Must # of fields in the 2 tables in an Append Query be equal?


« Previous Thread | Next Thread »

 
 
Thread Tools Display Modes
  #1  
Old October 1st, 2004, 03:33 PM
CreativeImages
external usenet poster
  
Posts: n/a
Default Must # of fields in the 2 tables in an Append Query be equal?
I am trying the use a query to modify some data and append the modified data
to an existing table. The source table has forty some field. The
destination table has seven fields.

I keep getting the “INSERT INTO statement contains the following field name:
‘Owner`”. Make sure you have typed the name correctly, and try the operation
again.”

Do the two tables have to have the exact same number of fields to move data?
What am I over looking?
  #2  
Old October 1st, 2004, 03:41 PM
Brendan Reynolds
external usenet poster
  
Posts: n/a
Default
The tables don't have to have the same number of fields, but in your query
you should select from the source table only those fields that you intend to
append to the target table. If there are fields in the source table that you
don't intend to append to the target table, don't select those fields in the
query.

If you're still stuck after reading this, try posting the SQL for the query
(in query design view, select SQL View from the View menu).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"CreativeImages" wrote in message
...
I am trying the use a query to modify some data and append the modified
data
to an existing table. The source table has forty some field. The
destination table has seven fields.

I keep getting the "INSERT INTO statement contains the following field
name:
'Owner`". Make sure you have typed the name correctly, and try the
operation
again."

Do the two tables have to have the exact same number of fields to move
data?
What am I over looking?
  #3  
Old October 1st, 2004, 04:17 PM
CreativeImages
external usenet poster
  
Posts: n/a
Default

I am struggling with Access; I barely understand SGL, and I am not using SGL
(directly). From someplace in the Access Query Design, there is this SGL
coding:

INSERT INTO [tbl-Streets] ( Jurisdiction, Source, [Number], Alpha, Street,
Type, ID, MapNumber )
SELECT [qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].*,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Jurisdiction,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Source,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Number,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Alpha,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Street,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Type,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].ID,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].MapNumber
FROM [qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly];

The above SGL instruction was created by using the Access Query Design and
Expression Builder. When I try to run this query, I get the error message
“INSERT INTO statement contains the following field name: ‘Owner`”. Make
sure you have typed the name correctly, and try the operation again.” When I
add the field “Owner,” the next field in the source data but not used in
destination table appears in the error statement.

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 1

Properties

DateCreated: 8/15/2004 9:37:31 AM DefaultView:
Datasheet
GUID: {guid {DCBB7C49- LastUpdated:
9/30/2004 10:28:50 AM
442F-483F-AD65-
NameMap: Long binary data OrderByOn:
True

Orientation: Left-to-Right RecordCount:
2
Updatable: True

Columns

Name Type
Size

Number Long Integer
4
AllowZeroLength: False

Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False

ColumnOrder: 1
ColumnWidth: 855
DataUpdatable: False
DecimalPlaces: Auto

DisplayControl: Text Box
GUID: {guid
{D391D4A7-88C6-413B-BA26-7DD246196EBE}}
OrdinalPosition: 0

Required: False
SourceField: Number
SourceTable: tbl-Streets

Alpha Text
50
AllowZeroLength: True
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default

ColumnWidth: 675
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {C429F1DC-BFD7-43EF-BA3E-

IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1

Required: False
SourceField: Alpha
SourceTable: tbl-Streets
UnicodeCompression: True

Street Text
50
AllowZeroLength: True

Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 1260
DataUpdatable: False

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 2

DisplayControl: Text Box
GUID: {guid {A2B2D17C-E7CE-40F8-BE3C-
IMEMode: 0

IMESentenceMode: 3
OrdinalPosition: 2
Required: False

SourceField: Street
SourceTable: tbl-Streets
UnicodeCompression: True

Type Text
3
AllowZeroLength: True
Attributes: Variable Length

BoundColumn: 1
CollatingOrder: General
ColumnCount: 1

ColumnHeads: False
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 615

DataUpdatable: False
DisplayControl: Combo Box
GUID: {guid
{E1644FFC-9269-4E68-9A25-51F6D504AB9F}}

IMEMode: 0
IMESentenceMode: 3
LimitToList: False
ListRows: 8

ListWidth: 0twip
OrdinalPosition: 3
Required: False

RowSourceType: Table/Query
SourceField: Type
SourceTable: tbl-Streets
UnicodeCompression: True

City Text
50
AllowZeroLength: True

Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 930
DataUpdatable: False
DisplayControl: Text Box

GUID: {guid
{484F3C6F-1D1F-4AB7-A328-D465242614FF}}
IMEMode: 0
IMESentenceMode: 3

OrdinalPosition: 4
Required: False
SourceField: City
SourceTable: tbl-Streets

UnicodeCompression: True

State Text
50

AllowZeroLength: True

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 3

Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default

ColumnWidth: 645
DataUpdatable: False
DisplayControl: Text Box

GUID: {guid {A9BF01BE-E1CD-4B1D-8165-
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 5

Required: False
SourceField: State
SourceTable: tbl-Streets

UnicodeCompression: True

Zip Long Integer
4

AllowZeroLength: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 705
DataUpdatable: False

DecimalPlaces: 0
DisplayControl: Text Box
GUID: {guid
{1B160009-B1CA-48CA-8157-207094FEF52C}}
InputMask: 99999

OrdinalPosition: 6
Required: False
SourceField: Zip

SourceTable: tbl-Streets

PlusFour Long Integer
4

AllowZeroLength: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 960
DataUpdatable: False

DecimalPlaces: 0
DisplayControl: Text Box
GUID: {guid
{15E0B6D0-52AD-45EF-A0BC-847F51F29C33}}
OrdinalPosition: 7

Required: False
SourceField: PlusFour
SourceTable: tbl-Streets

Jurisdiction Text
50
AllowZeroLength: True
Attributes: Variable Length

BoundColumn: 1
CollatingOrder: General
ColumnCount: 1

ColumnHeads: False

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 4

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 3075
ColumnWidths: 1440

DataUpdatable: False
DisplayControl: Combo Box
GUID: {guid {FC8C5821-EBE8-42C5-ACE8-

IMEMode: 0
IMESentenceMode: 3
LimitToList: False
ListRows: 8

ListWidth: 1440twip
OrdinalPosition: 8
Required: False

RowSourceType: Value List
SourceField: Jurisdiction
SourceTable: tbl-Streets

UnicodeCompression: True

TaxNumber Text
50
AllowZeroLength: True

Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 1770
DataUpdatable: False
DisplayControl: Text Box

GUID: {guid
{6F2EAFFC-21BA-4839-8523-32C57EC98359}}
IMEMode: 0
IMESentenceMode: 3

OrdinalPosition: 9
Required: False
SourceField: TaxNumber
SourceTable: tbl-Streets

UnicodeCompression: True

MapCoorindinates Text
50

AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1740
DataUpdatable: False

DisplayControl: Text Box
GUID: {guid
{65349B66-D510-4A52-9959-06E830F97CF9}}
IMEMode: 0

IMESentenceMode: 3
OrdinalPosition: 10
Required: False
SourceField: MapCoorindinates

SourceTable: tbl-Streets
UnicodeCompression: True


MapNumber Text
50

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 5

AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 1230
DataUpdatable: False

DisplayControl: Text Box
GUID: {guid
{119FA506-CC1E-4A3C-8A67-53D61F9F2462}}
IMEMode: 0
IMESentenceMode: 3

OrdinalPosition: 11
Required: False
SourceField: MapNumber

SourceTable: tbl-Streets
UnicodeCompression: True

MapQuest1 OLE Object
-
AllowZeroLength: False
Attributes: Variable Length
CollatingOrder: General

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1185

DataUpdatable: False
GUID: {guid
{2A4CBE6C-6421-4ADC-89E7-786A5345B46B}}
OrdinalPosition: 12
Required: False

SourceField: MapQuest1
SourceTable: tbl-Streets

MapQuest2 OLE Object
-
AllowZeroLength: False
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1185

DataUpdatable: False
GUID: {guid
{7E28B8DD-35BE-4E43-841D-477E9A44C3E9}}
OrdinalPosition: 13

Required: False
SourceField: MapQuest2
SourceTable: tbl-Streets

DrivingDirections Memo
-
AllowZeroLength: True
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1620

DataUpdatable: False
GUID: {guid
{30837220-2E81-456A-AE5D-B03C81F90B55}}
IMEMode: 0

IMESentenceMode: 3

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 6

OrdinalPosition: 14
Required: False
SourceField: DrivingDirections
SourceTable: tbl-Streets

UnicodeCompression: True

Source Text
50

AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 795
DataUpdatable: False

DisplayControl: Text Box
GUID: {guid
{A5467786-D1BB-4A62-AB1E-4710556A80E8}}
IMEMode: 0

IMESentenceMode: 3
OrdinalPosition: 15
Required: False
SourceField: Source

SourceTable: tbl-Streets
UnicodeCompression: True

ID Text
50
AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 360

DataUpdatable: False
DisplayControl: Text Box
GUID: {guid
{E2A7A085-4A0A-4C04-8E73-42475CAEF5E3}}

IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 16
Required: False

SourceField: ID
SourceTable: tbl-Streets
UnicodeCompression: True

SourceDate Text
50
AllowZeroLength: True
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default

ColumnWidth: 1200
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid
{78E92E47-F8C5-4F8D-B023-DD93ADB47242}}

IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 17

Required: False

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 7

SourceField: SourceDate
SourceTable: tbl-Streets
UnicodeCompression: True

Permit Text
50
AllowZeroLength: True
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default

ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid
{DE3C9C11-A6E6-4445-981B-A0510CE8F8AE}}

IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 18

Required: False
SourceField: Permit
SourceTable: tbl-Streets
UnicodeCompression: True

Table Indexes
Name Number of

ID 1
Clustered: False

DistinctCount: 1
Foreign: False
IgnoreNulls: False

Name: ID
Primary: False
Required: False

Unique: False
Fields:
ID Ascending

Number 1
Clustered: False
DistinctCount: 2

Foreign: False
IgnoreNulls: False
Name: Number

Primary: False
Required: False
Unique: False

Fields:
Number Ascending

StreetTypesShort 1
Clustered: False
DistinctCount: 1

Foreign: False
IgnoreNulls: False
Name: StreetTypesShort

Primary: False
Required: False

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 8

Unique: False
Fields:

Type Ascending

User Permissions

admin Delete, Read Permissions, Set
Permissions, Change Owner,
Read Definition, Write Definition, Read
Data, Insert Data,

Group Permissions
Admins Delete, Read Permissions, Set
Permissions, Change Owner,
Read Definition, Write Definition, Read
Data, Insert Data,
Users Delete, Read Permissions, Set
Permissions, Change Owner,
Read Definition, Write Definition, Read
Data, Insert Data,


"Brendan Reynolds" wrote:

The tables don't have to have the same number of fields, but in your query
you should select from the source table only those fields that you intend to
append to the target table. If there are fields in the source table that you
don't intend to append to the target table, don't select those fields in the
query.

If you're still stuck after reading this, try posting the SQL for the query
(in query design view, select SQL View from the View menu).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"CreativeImages" wrote in message
...
I am trying the use a query to modify some data and append the modified
data
to an existing table. The source table has forty some field. The
destination table has seven fields.

I keep getting the "INSERT INTO statement contains the following field
name:
'Owner`". Make sure you have typed the name correctly, and try the
operation
again."

Do the two tables have to have the exact same number of fields to move
data?
What am I over looking?
  #4  
Old October 1st, 2004, 05:16 PM
Brendan Reynolds
external usenet poster
  
Posts: n/a
Default
It's SQL, not SGL. The problem is the first line in the SELECT clause, the
line ending with "*". The "*" tells Access to include all fields.

The key is that the number of target fields between the parentheses in the
INSERT INTO clause (Jurisdiction, Source, [Number], Alpha, Street, Type, ID,
MapNumber) must match the number of source fields in the SELECT clause. Take
out the line ending with the "*"
([qry-ConvertingRawFCBP'sToBildingPermits-QueryOnly'.*,) so that the SQL
looks like this ...

INSERT INTO [tbl-Streets] (Jurisdiction, Source, [Number], Alpha, Street,
Type, ID, MapNumber)
SELECT [qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly.Jurisdiction,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Source, etc.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"CreativeImages" wrote in message
...

I am struggling with Access; I barely understand SGL, and I am not using
SGL
(directly). From someplace in the Access Query Design, there is this SGL
coding:

INSERT INTO [tbl-Streets] ( Jurisdiction, Source, [Number], Alpha, Street,
Type, ID, MapNumber )
SELECT [qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].*,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Jurisdiction,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Source,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Number,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Alpha,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Street,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].Type,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].ID,
[qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly].MapNumber
FROM [qry-ConvertingRawFCBP'sToBuildingPermits-QueryOnly];

The above SGL instruction was created by using the Access Query Design and
Expression Builder. When I try to run this query, I get the error message
"INSERT INTO statement contains the following field name: 'Owner`". Make
sure you have typed the name correctly, and try the operation again."
When I
add the field "Owner," the next field in the source data but not used in
destination table appears in the error statement.

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 1

Properties

DateCreated: 8/15/2004 9:37:31 AM DefaultView:
Datasheet
GUID: {guid {DCBB7C49- LastUpdated:
9/30/2004 10:28:50 AM
442F-483F-AD65-
NameMap: Long binary data OrderByOn:
True

Orientation: Left-to-Right RecordCount:
2
Updatable: True

Columns

Name Type
Size

Number Long Integer
4
AllowZeroLength: False

Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False

ColumnOrder: 1
ColumnWidth: 855
DataUpdatable: False
DecimalPlaces: Auto

DisplayControl: Text Box
GUID: {guid
{D391D4A7-88C6-413B-BA26-7DD246196EBE}}
OrdinalPosition: 0

Required: False
SourceField: Number
SourceTable: tbl-Streets

Alpha Text
50
AllowZeroLength: True
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default

ColumnWidth: 675
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid
{C429F1DC-BFD7-43EF-BA3E-

IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1

Required: False
SourceField: Alpha
SourceTable: tbl-Streets
UnicodeCompression: True

Street Text
50
AllowZeroLength: True

Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 1260
DataUpdatable: False

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 2

DisplayControl: Text Box
GUID: {guid
{A2B2D17C-E7CE-40F8-BE3C-
IMEMode: 0

IMESentenceMode: 3
OrdinalPosition: 2
Required: False

SourceField: Street
SourceTable: tbl-Streets
UnicodeCompression: True

Type Text
3
AllowZeroLength: True
Attributes: Variable Length

BoundColumn: 1
CollatingOrder: General
ColumnCount: 1

ColumnHeads: False
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 615

DataUpdatable: False
DisplayControl: Combo Box
GUID: {guid
{E1644FFC-9269-4E68-9A25-51F6D504AB9F}}

IMEMode: 0
IMESentenceMode: 3
LimitToList: False
ListRows: 8

ListWidth: 0twip
OrdinalPosition: 3
Required: False

RowSourceType: Table/Query
SourceField: Type
SourceTable: tbl-Streets
UnicodeCompression: True

City Text
50
AllowZeroLength: True

Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 930
DataUpdatable: False
DisplayControl: Text Box

GUID: {guid
{484F3C6F-1D1F-4AB7-A328-D465242614FF}}
IMEMode: 0
IMESentenceMode: 3

OrdinalPosition: 4
Required: False
SourceField: City
SourceTable: tbl-Streets

UnicodeCompression: True

State Text
50

AllowZeroLength: True

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 3

Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default

ColumnWidth: 645
DataUpdatable: False
DisplayControl: Text Box

GUID: {guid
{A9BF01BE-E1CD-4B1D-8165-
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 5

Required: False
SourceField: State
SourceTable: tbl-Streets

UnicodeCompression: True

Zip Long Integer
4

AllowZeroLength: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 705
DataUpdatable: False

DecimalPlaces: 0
DisplayControl: Text Box
GUID: {guid
{1B160009-B1CA-48CA-8157-207094FEF52C}}
InputMask: 99999

OrdinalPosition: 6
Required: False
SourceField: Zip

SourceTable: tbl-Streets

PlusFour Long Integer
4

AllowZeroLength: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 960
DataUpdatable: False

DecimalPlaces: 0
DisplayControl: Text Box
GUID: {guid
{15E0B6D0-52AD-45EF-A0BC-847F51F29C33}}
OrdinalPosition: 7

Required: False
SourceField: PlusFour
SourceTable: tbl-Streets

Jurisdiction Text
50
AllowZeroLength: True
Attributes: Variable Length

BoundColumn: 1
CollatingOrder: General
ColumnCount: 1

ColumnHeads: False

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 4

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 3075
ColumnWidths: 1440

DataUpdatable: False
DisplayControl: Combo Box
GUID: {guid
{FC8C5821-EBE8-42C5-ACE8-

IMEMode: 0
IMESentenceMode: 3
LimitToList: False
ListRows: 8

ListWidth: 1440twip
OrdinalPosition: 8
Required: False

RowSourceType: Value List
SourceField: Jurisdiction
SourceTable: tbl-Streets

UnicodeCompression: True

TaxNumber Text
50
AllowZeroLength: True

Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 1770
DataUpdatable: False
DisplayControl: Text Box

GUID: {guid
{6F2EAFFC-21BA-4839-8523-32C57EC98359}}
IMEMode: 0
IMESentenceMode: 3

OrdinalPosition: 9
Required: False
SourceField: TaxNumber
SourceTable: tbl-Streets

UnicodeCompression: True

MapCoorindinates Text
50

AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1740
DataUpdatable: False

DisplayControl: Text Box
GUID: {guid
{65349B66-D510-4A52-9959-06E830F97CF9}}
IMEMode: 0

IMESentenceMode: 3
OrdinalPosition: 10
Required: False
SourceField: MapCoorindinates

SourceTable: tbl-Streets
UnicodeCompression: True


MapNumber Text
50

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 5

AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False

ColumnOrder: Default
ColumnWidth: 1230
DataUpdatable: False

DisplayControl: Text Box
GUID: {guid
{119FA506-CC1E-4A3C-8A67-53D61F9F2462}}
IMEMode: 0
IMESentenceMode: 3

OrdinalPosition: 11
Required: False
SourceField: MapNumber

SourceTable: tbl-Streets
UnicodeCompression: True

MapQuest1 OLE Object
-
AllowZeroLength: False
Attributes: Variable Length
CollatingOrder: General

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1185

DataUpdatable: False
GUID: {guid
{2A4CBE6C-6421-4ADC-89E7-786A5345B46B}}
OrdinalPosition: 12
Required: False

SourceField: MapQuest1
SourceTable: tbl-Streets

MapQuest2 OLE Object
-
AllowZeroLength: False
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1185

DataUpdatable: False
GUID: {guid
{7E28B8DD-35BE-4E43-841D-477E9A44C3E9}}
OrdinalPosition: 13

Required: False
SourceField: MapQuest2
SourceTable: tbl-Streets

DrivingDirections Memo
-
AllowZeroLength: True
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1620

DataUpdatable: False
GUID: {guid
{30837220-2E81-456A-AE5D-B03C81F90B55}}
IMEMode: 0

IMESentenceMode: 3

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 6

OrdinalPosition: 14
Required: False
SourceField: DrivingDirections
SourceTable: tbl-Streets

UnicodeCompression: True

Source Text
50

AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 795
DataUpdatable: False

DisplayControl: Text Box
GUID: {guid
{A5467786-D1BB-4A62-AB1E-4710556A80E8}}
IMEMode: 0

IMESentenceMode: 3
OrdinalPosition: 15
Required: False
SourceField: Source

SourceTable: tbl-Streets
UnicodeCompression: True

ID Text
50
AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General

ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 360

DataUpdatable: False
DisplayControl: Text Box
GUID: {guid
{E2A7A085-4A0A-4C04-8E73-42475CAEF5E3}}

IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 16
Required: False

SourceField: ID
SourceTable: tbl-Streets
UnicodeCompression: True

SourceDate Text
50
AllowZeroLength: True
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default

ColumnWidth: 1200
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid
{78E92E47-F8C5-4F8D-B023-DD93ADB47242}}

IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 17

Required: False

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 7

SourceField: SourceDate
SourceTable: tbl-Streets
UnicodeCompression: True

Permit Text
50
AllowZeroLength: True
Attributes: Variable Length

CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default

ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid
{DE3C9C11-A6E6-4445-981B-A0510CE8F8AE}}

IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 18

Required: False
SourceField: Permit
SourceTable: tbl-Streets
UnicodeCompression: True

Table Indexes
Name Number of

ID 1
Clustered: False

DistinctCount: 1
Foreign: False
IgnoreNulls: False

Name: ID
Primary: False
Required: False

Unique: False
Fields:
ID Ascending

Number 1
Clustered: False
DistinctCount: 2

Foreign: False
IgnoreNulls: False
Name: Number

Primary: False
Required: False
Unique: False

Fields:
Number Ascending

StreetTypesShort 1
Clustered: False
DistinctCount: 1

Foreign: False
IgnoreNulls: False
Name: StreetTypesShort

Primary: False
Required: False

D:\Doc\ADT.mdb
Friday, October 01, 2004

Table: tbl-Streets
Page: 8

Unique: False
Fields:

Type Ascending

User Permissions

admin Delete, Read Permissions, Set
Permissions, Change Owner,
Read Definition, Write Definition, Read
Data, Insert Data,

Group Permissions
Admins Delete, Read Permissions, Set
Permissions, Change Owner,
Read Definition, Write Definition, Read
Data, Insert Data,
Users Delete, Read Permissions, Set
Permissions, Change Owner,
Read Definition, Write Definition, Read
Data, Insert Data,


"Brendan Reynolds" wrote:

The tables don't have to have the same number of fields, but in your
query
you should select from the source table only those fields that you intend
to
append to the target table. If there are fields in the source table that
you
don't intend to append to the target table, don't select those fields in
the
query.

If you're still stuck after reading this, try posting the SQL for the
query
(in query design view, select SQL View from the View menu).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible
for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"CreativeImages" wrote in
message
...
I am trying the use a query to modify some data and append the modified
data
to an existing table. The source table has forty some field. The
destination table has seven fields.

I keep getting the "INSERT INTO statement contains the following field
name:
'Owner`". Make sure you have typed the name correctly, and try the
operation
again."

Do the two tables have to have the exact same number of fields to move
data?
What am I over looking?
 



« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
query fields Elsie General Discussion 4 August 24th, 2004 06:05 AM
"UNION" Query with different fields in the two tables Dkline Running & Setting Up Queries 5 July 30th, 2004 09:05 PM
Append Query problem -- producing WAY too many records. Richard Hollenbeck Running & Setting Up Queries 3 July 24th, 2004 09:32 AM
Newbie? Do I use Report or Query John Egan New Users 11 June 28th, 2004 08:31 PM
Use a make-table query to combine two existing tables Matt Running & Setting Up Queries 1 June 16th, 2004 01:53 AM


All times are GMT +1. The time now is 02:21 PM.

Feed Icon - Contact Us - OfficeFrustration excel & word help home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.