将mysql dump或文本文件加载到Microsoft Access 2003中 [英] loading mysql dump or text file into microsoft access 2003

问题描述

我不是MS Access方面的专家，基本上给我一个文本文件，其中包含超过十万条记录，并被要求将该文本文件加载到MS Access数据库中.据我所知，我首先使用正常的加载文本文件"命令将该文本文件上传到MySQL数据库中，并且按预期工作.但是，在Access 2003中，当我进入文件菜单以获取外部数据并浏览文本文件时，选择文件后它什么也没做.

I am not an expert in MS Access, I have been given a text files basically with over hundred thousand records in it and have been asked to load that text file into the MS access database. As I know MySQL, I uploaded that text file into the MySQL database first using normal Load text file command and it worked as expected. However, when in Access 2003, I go to file menu to Get external data and browse the text file, it just don't do anything after I select the file.

我尝试通过SQL转储进行加载，创建了一个表，切换到了SQL查询，但是我无法将所有这些插入命令复制粘贴到其中，因为事实上它说值太大而无法输入，由于记录数量巨大，我无法一一粘贴.

I have tried loading through SQL dump, I created a table, switched to the SQL query but I can not copy paste all of those insert commands in it, as a matter of fact it says value is too big to be entered and I can not paste them one by one as the record number is huge.

有任何帮助吗?我将不胜感激.

Any one help? I will be grateful.

推荐答案

我尚不清楚是什么原因导致您无法直接导入文本文件.您必须提供有关Access中正在尝试的内容以及出现问题的地方的更多详细信息.

It's not clear to me what would cause you to be unable to import the text file directly. You'll have to give more details on what you're attempting in Access and where it's going wrong.

但是，如果您已经在MySQL中获取了数据并想要从那里导入，请为您的MySQL数据库创建一个DSN，然后使用来自ODBC的IMPORT，指向DSN，然后就可以导入表了从MySQL到Access.一次也可以处理多个表.

But if you've got the data in MySQL already and want to import from there, create a DSN for your MySQL database, then use IMPORT from ODBC, point to the DSN, and you'll be able to import the table from MySQL into Access. It also works with multiple tables at a time.

这篇关于将mysql dump或文本文件加载到Microsoft Access 2003中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！