从excel读取大数据并在数据库中写入 [英] Large data read from excel and write in database

问题描述

我在excel中有大量数据想要读取它并将其存储在数据库中。我能够创建数据库和创建表，但无法在访问中插入大数据。我在一个文件中有1000行和5列，但在访问时写入它只能写入370.任何人都可以告诉我，这可能是什么缺陷

I have large data in excel want to read it and store it in database. I am able to create database and create table , but not able to insert large data in access. I am having 1000 row and 5 columns in a file, but while writing it in access, it gets write only 370. Can anyone tell me, what could be the flaw

推荐答案

仅回答从未答复列表中删除 - 由OP解决。

Answered only to remove from unanswered list - solved by OP.

这篇关于从excel读取大数据并在数据库中写入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！