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 2fota database,1.create table bicycle parking32 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 BIGINTK11017...92D..RunSaveScheduleClear93...Ouery resulksTahle detailsm 4n678 99 FileHomeInsertPage LayoutFormulasDataReviewViewà From AccessO Show QueriesO Connections21 HAClearE Flash FillConsol8-B Remove Duplicates Relationle From WebE From TablePropertiesDOReapplyFilterFrom OtherExistingConnections Query - Lo Recent SourcesNewG From TextRefreshAll- la Edit LinksZL SortSourcesText toAdvancedColumns Data Validation-ManageGet External DataGet & TransformConnectionsSort & FilterData ToolsA17fe151.207344997BD1 XYOBJECTIDAssetIDGТуреStreetNameHarbour StreetSuburb151.2024332 -33.87430961151.2161059 -33.88325102151.198217 -33.870235012Postcode1461 BIKE15Bike Maintenance StandSydneySurry HillsSydneySydney314622000404691 Bike Maintenance StandBourke Street41463394233 Bike Maintenance Stand2010151.212075 -33.87651806Darling Drive1464404840 Bike Maintenance Stand2000Liverpool Street151.202647 -33.8809140114652000406023 U-Rail7151.202678Ultimo RoadHaymarket-33.8809041466406025 U-Rail2000Ultimo RoadHaymarketSurry HillsSydneySydney8151.209721 -33.8812889914672000404903 U-RailReservoir Street151.207949 -33.8745769914682010405330 U-RailPitt Street10151.208954 -33.874706031469405304 U-Rail2000Castlereagh Street200011151.203028 -33.858380991470405841 U-RailArgyle PlaceMillers Point12151.191976 -33.863857011471394191 U-Rail2000Pirrama Road13151.2033759 -33.87945697Pyrmont20091472405802 U-Rail14151.203403 -33.87946404Hay StreetHaymarket20001473405803 U-RailHay StreetHaymarket1516151.2034361 -33.8794660614742000405804 U-Rail151.203439 -33.87946006Hay StreetHaymarket20001475405805 U-Rail151.207345| -33.85570103Hay StreetHaymarket1720001476406089 U-RailHickson RoadMillers Point181920151.207322-33.855731477406090 U-Rail2000Pottinger StreetDalgety RoadPyrmont Bridge RoadDawes Point151.202358 -33.8580089814782000406199 U-Rail151.197133 -33.87010706Millers Point20001479394229 U-Rail21151.2014929 -33.88260001Pyrmont20091480406186 U-Rail22151.2015Harris StreetUltimo-33.8825811481406187 U-Rail200723151.201469 -33.88255404Harris StreetUltimo20071482406188 U-RailHarris StreetUltimo151.20144122.002 5020420071402Bicycle_parkingHarric Ctennt2007ReadyCalculate

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 2fota database,1.create table bicycle parking32 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 BIGINTK1>1017...92D..RunSaveScheduleClear93...Ouery resulksTahle detailsm 4n678 99 FileHomeInsertPage LayoutFormulasDataReviewViewà From AccessO Show QueriesO Connections21 HAClearE Flash FillConsol8-B Remove Duplicates Relationle From WebE From TablePropertiesDOReapplyFilterFrom OtherExistingConnections Query - Lo Recent SourcesNewG From TextRefreshAll- la Edit LinksZL SortSourcesText toAdvancedColumns Data Validation-ManageGet External DataGet & TransformConnectionsSort & FilterData ToolsA17fe151.207344997BD1 XYOBJECTIDAssetIDGТуреStreetNameHarbour StreetSuburb151.2024332 -33.87430961151.2161059 -33.88325102151.198217 -33.870235012Postcode1461 BIKE15Bike Maintenance StandSydneySurry HillsSydneySydney314622000404691 Bike Maintenance StandBourke Street41463394233 Bike Maintenance Stand2010151.212075 -33.87651806Darling Drive1464404840 Bike Maintenance Stand2000Liverpool Street151.202647 -33.8809140114652000406023 U-Rail7151.202678Ultimo RoadHaymarket-33.8809041466406025 U-Rail2000Ultimo RoadHaymarketSurry HillsSydneySydney8151.209721 -33.8812889914672000404903 U-RailReservoir Street151.207949 -33.8745769914682010405330 U-RailPitt Street10151.208954 -33.874706031469405304 U-Rail2000Castlereagh Street200011151.203028 -33.858380991470405841 U-RailArgyle PlaceMillers Point12151.191976 -33.863857011471394191 U-Rail2000Pirrama Road13151.2033759 -33.87945697Pyrmont20091472405802 U-Rail14151.203403 -33.87946404Hay StreetHaymarket20001473405803 U-RailHay StreetHaymarket1516151.2034361 -33.8794660614742000405804 U-Rail151.203439 -33.87946006Hay StreetHaymarket20001475405805 U-Rail151.207345| -33.85570103Hay StreetHaymarket1720001476406089 U-RailHickson RoadMillers Point181920151.207322-33.855731477406090 U-Rail2000Pottinger StreetDalgety RoadPyrmont Bridge RoadDawes Point151.202358 -33.8580089814782000406199 U-Rail151.197133 -33.87010706Millers Point20001479394229 U-Rail21151.2014929 -33.88260001Pyrmont20091480406186 U-Rail22151.2015Harris StreetUltimo-33.8825811481406187 U-Rail200723151.201469 -33.88255404Harris StreetUltimo20071482406188 U-RailHarris StreetUltimo151.20144122.002 5020420071402Bicycle_parkingHarric Ctennt2007ReadyCalculate

Accepted Answer

It is defined as a request for data results, and for action on data. You can use a query to answer a…

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