use the query to create a table exactly like the first photo but it said ERROR: Load into table ‘bicycle’ failed. Check ‘stl_load_errors’ system table for details. What should i do

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
i use the query to create a table exactly like the first photo but it said ERROR: Load into table ‘bicycle’ failed. Check ‘stl_load_errors’ system table for details. What should i do?
Query 2
fo
ta database,
1.
create table bicycle parking3
2 X decimal (10,5),
3 Y decimal (10,5),
a schema.
4.
OBJECTID int,
5AssetID varchar (255),
6 Type varchar (255),
StreetName varchar (255),
Suburb varchar(255),
Postcode BIGINT
K1>
1017
...
92
D..
Run
Save
Schedule
Clear
93
...
Ouery resulks
Tahle details
m 4n
678 99
Transcribed Image Text:Query 2 fo ta database, 1. create table bicycle parking3 2 X decimal (10,5), 3 Y decimal (10,5), a schema. 4. OBJECTID int, 5AssetID varchar (255), 6 Type varchar (255), StreetName varchar (255), Suburb varchar(255), Postcode BIGINT K1> 1017 ... 92 D.. Run Save Schedule Clear 93 ... Ouery resulks Tahle details m 4n 678 99
File
Home
Insert
Page Layout
Formulas
Data
Review
View
à From Access
O Show Queries
O Connections
21 HA
Clear
E Flash Fill
Consol
8-B Remove Duplicates Relation
le From Web
E From Table
Properties
DO
Reapply
Filter
From Other
Existing
Connections Query - Lo Recent Sources
New
G From Text
Refresh
All- la Edit Links
ZL Sort
Sources
Text to
Advanced
Columns Data Validation-
Manage
Get External Data
Get & Transform
Connections
Sort & Filter
Data Tools
A17
fe
151.207344997
B
D
1 X
Y
OBJECTID
AssetID
G
Туре
StreetName
Harbour Street
Suburb
151.2024332 -33.87430961
151.2161059 -33.88325102
151.198217 -33.87023501
2
Postcode
1461 BIKE15
Bike Maintenance Stand
Sydney
Surry Hills
Sydney
Sydney
3
1462
2000
404691 Bike Maintenance Stand
Bourke Street
4
1463
394233 Bike Maintenance Stand
2010
151.212075 -33.87651806
Darling Drive
1464
404840 Bike Maintenance Stand
2000
Liverpool Street
151.202647 -33.88091401
1465
2000
406023 U-Rail
7
151.202678
Ultimo Road
Haymarket
-33.880904
1466
406025 U-Rail
2000
Ultimo Road
Haymarket
Surry Hills
Sydney
Sydney
8
151.209721 -33.88128899
1467
2000
404903 U-Rail
Reservoir Street
151.207949 -33.87457699
1468
2010
405330 U-Rail
Pitt Street
10
151.208954 -33.87470603
1469
405304 U-Rail
2000
Castlereagh Street
2000
11
151.203028 -33.85838099
1470
405841 U-Rail
Argyle Place
Millers Point
12
151.191976 -33.86385701
1471
394191 U-Rail
2000
Pirrama Road
13
151.2033759 -33.87945697
Pyrmont
2009
1472
405802 U-Rail
14
151.203403 -33.87946404
Hay Street
Haymarket
2000
1473
405803 U-Rail
Hay Street
Haymarket
15
16
151.2034361 -33.87946606
1474
2000
405804 U-Rail
151.203439 -33.87946006
Hay Street
Haymarket
2000
1475
405805 U-Rail
151.207345| -33.85570103
Hay Street
Haymarket
17
2000
1476
406089 U-Rail
Hickson Road
Millers Point
18
19
20
151.207322
-33.85573
1477
406090 U-Rail
2000
Pottinger Street
Dalgety Road
Pyrmont Bridge Road
Dawes Point
151.202358 -33.85800898
1478
2000
406199 U-Rail
151.197133 -33.87010706
Millers Point
2000
1479
394229 U-Rail
21
151.2014929 -33.88260001
Pyrmont
2009
1480
406186 U-Rail
22
151.2015
Harris Street
Ultimo
-33.882581
1481
406187 U-Rail
2007
23
151.201469 -33.88255404
Harris Street
Ultimo
2007
1482
406188 U-Rail
Harris Street
Ultimo
151.201441
22.002 50204
2007
1402
Bicycle_parking
Harric Ctennt
2007
Ready
Calculate
Transcribed Image Text:File Home Insert Page Layout Formulas Data Review View à From Access O Show Queries O Connections 21 HA Clear E Flash Fill Consol 8-B Remove Duplicates Relation le From Web E From Table Properties DO Reapply Filter From Other Existing Connections Query - Lo Recent Sources New G From Text Refresh All- la Edit Links ZL Sort Sources Text to Advanced Columns Data Validation- Manage Get External Data Get & Transform Connections Sort & Filter Data Tools A17 fe 151.207344997 B D 1 X Y OBJECTID AssetID G Туре StreetName Harbour Street Suburb 151.2024332 -33.87430961 151.2161059 -33.88325102 151.198217 -33.87023501 2 Postcode 1461 BIKE15 Bike Maintenance Stand Sydney Surry Hills Sydney Sydney 3 1462 2000 404691 Bike Maintenance Stand Bourke Street 4 1463 394233 Bike Maintenance Stand 2010 151.212075 -33.87651806 Darling Drive 1464 404840 Bike Maintenance Stand 2000 Liverpool Street 151.202647 -33.88091401 1465 2000 406023 U-Rail 7 151.202678 Ultimo Road Haymarket -33.880904 1466 406025 U-Rail 2000 Ultimo Road Haymarket Surry Hills Sydney Sydney 8 151.209721 -33.88128899 1467 2000 404903 U-Rail Reservoir Street 151.207949 -33.87457699 1468 2010 405330 U-Rail Pitt Street 10 151.208954 -33.87470603 1469 405304 U-Rail 2000 Castlereagh Street 2000 11 151.203028 -33.85838099 1470 405841 U-Rail Argyle Place Millers Point 12 151.191976 -33.86385701 1471 394191 U-Rail 2000 Pirrama Road 13 151.2033759 -33.87945697 Pyrmont 2009 1472 405802 U-Rail 14 151.203403 -33.87946404 Hay Street Haymarket 2000 1473 405803 U-Rail Hay Street Haymarket 15 16 151.2034361 -33.87946606 1474 2000 405804 U-Rail 151.203439 -33.87946006 Hay Street Haymarket 2000 1475 405805 U-Rail 151.207345| -33.85570103 Hay Street Haymarket 17 2000 1476 406089 U-Rail Hickson Road Millers Point 18 19 20 151.207322 -33.85573 1477 406090 U-Rail 2000 Pottinger Street Dalgety Road Pyrmont Bridge Road Dawes Point 151.202358 -33.85800898 1478 2000 406199 U-Rail 151.197133 -33.87010706 Millers Point 2000 1479 394229 U-Rail 21 151.2014929 -33.88260001 Pyrmont 2009 1480 406186 U-Rail 22 151.2015 Harris Street Ultimo -33.882581 1481 406187 U-Rail 2007 23 151.201469 -33.88255404 Harris Street Ultimo 2007 1482 406188 U-Rail Harris Street Ultimo 151.201441 22.002 50204 2007 1402 Bicycle_parking Harric Ctennt 2007 Ready Calculate
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY