ACCESS复制A数据库xx表到B数据库XX表？
用DELPHI怎么写代码，实现ACCESS复制A数据库xx表到B数据库XX表？
A数据库在优盘，B数据库在DELPHI所编写的EXE路径，通过单击确定按钮后，实数据库xx表复制到B数据库XX表？
在网上看到有人这样写：select * into XX in [A数据库路径] from XX，可是试了一下不行
请帮写全代码？
[解决办法]
比如adoquery1连接的是A数据库，那么
select * into tableB in 'c:\B.mdb' from tableA
[解决办法]
http://topic.csdn.net/u/20081106/11/c220fee2-8d20-43ac-ba25-0111a7fb9916.html?seed=424769032
[解决办法]
可以将这个SQL语句在MSSQL数据库运行一下看看
是不是代码有问题呀
[解决办法]
64保存数据到配置文件UINT32 SaveCmdDataToFile(PPNP_Report_MSG pstMsg){26 = 570;
UINT8 ucAddr= 570;UINT32 ulRet = CCU_ERR;PMANAGE485_CmdT pstCmd = 572; PCCU_CHAN_T pstChan = 572;
PRS485_BOARD_T pstNode = 572;CHECK; if (CCU_TRUE == IsCCUWorkInWireless(CCU_RESID)){221;}573;581; (VOID)575;
if ( 572 == pstNode ){ return CCU_485_ERR_NODE_INIT;}ulRet = GetCmdInfo(pstNode, (UINT8)pstMsg->uwCmd, &pstCmd);
if ( (CCU_OK != ulRet)|| (572 == pstCmd)){return CCU_485_ERR_CONFIG_CMD; }
/* 如果是查询类接口，不需调配置模块接口保持配置文件，直接返回 */
if ( 1 == pstCmd->ucDirType){221;}if ( pstMsg->uwSeq > TO_PNP_TAB_SIZE ){ return CCU_485_ERR_LENGTH_OVERLOAD;}
/* 如果命令执行成功，保存数据 */if ( CCU_OK == 577[576] ){
SaveCFGCmdData(pstMsg->ulResId, pstNode->enShelfType, (UINT8)pstMsg->uwCmd, pstNode->cBarCode, 5771, pstMsg->ulTempLen);
SaveCfgFileCmd(pstMsg->ulResId, (UINT8)pstMsg->uwCmd); }221;}
return CCU_OK 01 return CCU_ERR 02 CCU_NULL_PTR 03 CHECK_RET_OK(ulRet)04 CCU_NULL_BYTE 06
CCU_NULL_LONG 07 ulRet = IsResIdRight(pstMsg->ulResId, &ucChanNum, &ucAddr) 08
ulRet = GetChanNode(pstMsg->ulResId, &pstChan, &pstNode) 09 CCU_MemFree(CCU_MEM_INFO 11
g_ast485BoardInfo[ucChanNum][ucAddr] 14 pstMsg->aucCmdData 15 CCU_NODE_STATE_SYNC 17
CCU_NODE_STATE_NOREG 18 g_stCCUChan[ucChanNum].pstNodeList[ucAddr] = pstNode 21
MAX_REG_VER_LEN 22 pstMsg->ulLen 23 PRS485_BOARD_T pstNode 24 PCCU_CHAN_T pstChan 25
UINT8 ucChanNum 26 UINT8 ucAddr 27 UINT32 ulRet = CCU_ERR 31 CHECK_RET_OK_RN(ulRet, ulRet) 33
return CCU_ERR_MPI_INVALID_PARAMS 34 pstNode->enBoardType 35 pstNode->enHswState 36 if (CCU_OK != ulRet) 38
处理通道中的PNP上报回写消息 VOID ProcPnPMsg(PMANAGE_MSG_FRAME pstMsg)
PNP上报注册请求处理VOID ProcPnPReportRegInfo(PPNP_Report_EVT pstMsg)
PNP上报去注册事件处理VOID ProcPnPReportUnRegEvt(PPNP_Report_EVT pstMsg)
处理通信恢复事件UINT32 ProcCommResumeEvt(PPNP_Report_EVT pstMsg)
处理PNP上报的事件VOID ProcPnPEvt(PMANAGE_MSG_FRAME pstMsg)
{ PNP_RESP_MSG_TYPE enMsgType = PNP_RESP_INVALID_TYPE;PPNP_Report_MSG pstTempMsg = 03;CHECK;
pstTempMsg = (PPNP_Report_MSG)pstMsg->ucData;enMsgType = pstTempMsg->enType;
/* 将设置类数据保存到配置文件,必需在消息处理释放控制表之前保存 */SaveCmdDataToFile(pstTempMsg);
switch ( enMsgType ){case PNP_RESP_ASY_TYPE: /* 异步消息 */ProcRespAsyMsg(pstTempMsg);break;
case PNP_RESP_SYNC_TYPE:/* 同步消息 */ProcRespSynMsg(..);..;
case PNP_RESP_ALARM_TYPE: /* 告警消息 */ ProcRespAlarmMsg(..);..;default:break;}return;}
[解决办法]
你直接insert到B表中去阿!
