使用select folder导入访问表中的多个.mdb文件。 [英] Use select folder to import multiple .mdb files inside access table.
问题描述
各位大家，第一件事第一件，感谢bytes.com让我的问题在这里发布。我正在使用MS Access 2007，该文件已保存为MS Access 2000（.mdb）格式。目前我设法通过一个单击按钮将多个访问文件数据导入数据库（.mdb）文件。我正在尝试添加更多增强功能，以便用户可以选择源文件所在的文件夹，即; thumbdrive或我的文档或桌面，他们必须将这些文件放在" C：\ Solicitors报告Dashboard \SampleStorage \" ..我已经设法使用此代码：
Hi everybody, 1st thing 1st thanks to bytes.com for letting my question to be post here. I''m using MS Access 2007 and the file has been save as MS Access 2000 (.mdb) format. Currently I''m manage to import multiple access file data into database (.mdb) file with one click button. I''m trying to add more enhancement so the user can select the folder where the source file located i.e; thumbdrive or My Documents or Desktop instead they have to put those files inside "C:\Solicitors Report Dashboard\SampleStorage\".. I already manage to use this code :
推荐答案
您好Niheel，请重新合并我的第一篇文章（我的错误是我的错）因为那是我需要根据这些 Function SelectFolder &修改/增强的代码。 cmdExportExcel_Click 代码..我已经尝试更改代码，让用户选择里面包含多个源文件的文件夹。如果我在这里做错了，请随时通知我......我已经准备好学习...
Hi Niheel, please re-merge my 1st post (my bad for the mistake) as that is the code I need to modify/enhance base on these Function SelectFolder & cmdExportExcel_Click codes.. I already try to change the code to let the user to choose the folder which is contain the multiple source file inside. Feel free to inform me if I did something wrong here...I''m ready to learn...
你能发布用于导入多个文件的代码吗？当我们不知道你对导入的文件做了什么时，很难告诉你。
Can you post the code you are using to import multiple files? It''s difficult to advise you when we don''t know what you are doing with the imported files.
你好MMcCarthy，
对不起，我的英文不好希望你能抓住我想说的话。
不幸的是，这是我正在努力改变的代码，即使它已经达到了目的从我的数据库中的多个访问文件导入数据。当前代码指的是我设置的源文件的位置，即; " C：\SourceFiles\" &安培;这意味着每次我想要批量上传数据我需要将所有这些文件放在默认目录中，如上所述，现在我正在尝试更改它，以便用户可以在点击批量上传时指定这些源的位置。 （一次导入多个文件）按钮......每个月我都需要编制律师提供的所有数据来跟踪所有帐户的进度，即;民事诉讼，取消抵押品赎回权，拍卖前和拍卖后。
这是代码&我再次原谅我的英语不好&方式......
***我制作StoragePath，arcPath& mypath比真实目录短。
Hi MMcCarthy,
Sorry for my bad english hope you can catch what i am trying to say..
Unfortunately that''s the code i am trying change even it''s already achieve the purpose to import data from multiple access files inside my database. Current code is referring to location of source file as what i set i.e; "C:\SourceFiles\" & that mean every time i want to "bulk upload" the data 1st i need to put all those file inside the default directory as i set above, now i am trying to change that so user can appoint the location of those source when they click on the "bulk upload" (importing multiple files at once) button...every month i need to compile all data provided by solicitors to track all account progress i.e; civil action, foreclosure, pre-auction & post auction.
Here is the code & once again forgive me for my bad english & manner...
*** I make StoragePath,arcPath & mypath shorter than the real directory.
这篇关于使用select folder导入访问表中的多个.mdb文件。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
