从excel读取大数据并在数据库中写入
问题描述:
我在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.