本文介绍了快速问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 我相信大多数人这对我来说都是一个简单的答案,但对我而言,这是不是很好...... 我有一个数据库,我想将表格导出为Excel格式 ,以便我可以在掌上电脑上使用它。我不想要 表中的所有数据 - 只是当前成员的详细信息(我已经有一个查询显示 只有当前成员用于 数据库中其他地方的数量。 我可以设法将数据导出到excel文件并通过excel查看 但我也希望能够在远离我的PC(使用掌上电脑)的情况下对数据进行更改/更改,然后将数据导回到 主数据库。 我已经看过如何将数据导入当前表但是当我尝试将导入数据回到表中时不允许我这样做,因为它 会创建多个主键。 如何将表中的信息导出到excel然后再返回 在做出更改后会再次出现吗? 欢迎任何建议。 - Chris Naylor 取下你的裤子回复 http://www.neff.org.uk http://www.ireland2006eb.org.uk/ 否指出用大象制作一个小丘! 解决方案 < snip code> 对,更多解释然后... 数据库仅供我用来跟踪小熊队的详细信息和奖励 等。这些都存在于我的家用电脑上。我想要一种方法从数据库(Cub详细信息)中获取特定的表 并在我的PDA上查看/编辑。在PDA上进行更改/更新时,不会对PC上的数据库进行任何更改。 我在编码方面不是很好 - 我的大部分数据库建筑 非常基本。 - Chris Naylor 脱下你的裤子回复 http://www.neff.org.uk http://www.ireland2006eb.org.uk/ 乐观主义者认为未来不确定。 I''m sure that to most of you this will be an easy answer but to me itisn''t so here goes..I have a database that I want to export a table from into Excel formatso that I can use it on my palmtop. I don''t want all of the data in thetable - just current members details (I allready have a query to showonly current members that is used in a number of other places in thedatabase).I can manage to export the data to an excel file and view through excelbut I also want to be able to make aditions/changes to the data whileaway from my PC (using the palmtop) and then import the data back to themain database.I''ve seen how to import data into a current table but when I try toimport the data back to the table it won''t allow me to do so because itcreates multiple primary keys.How can I export the information from the table to excel and then backagain after making changes?Any suggestions welcomed.--Chris NaylorRemove your trousers to reply http://www.neff.org.uk http://www.ireland2006eb.org.uk/"No point in making a molehill out of an elephant!" 解决方案<snip code>Right, bit more explanation then...The database is only used by me to keep track of Cubs details and awardsetc. This lives on my home PC. I want a way to take a particular tablefrom the database (Cub Details) and view/edit on my PDA. No changes willbe made to database on PC while changes are made/updated on PDA.I''m not very good when it comes to coding - most of my database buildingis pretty basic.--Chris NaylorRemove your trousers to reply http://www.neff.org.uk http://www.ireland2006eb.org.uk/An optimist is someone who thinks the future is uncertain. 这篇关于快速问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!