A data table data about 200000 lines, but an EXCEL spreadsheet to accommodate more than 60000
How to judge exported to more than the maximum capacity of Sheet1, then automatically export to Sheet2 inside?
The second problem is that the ACCESS table band () in the fields, such as' village (house) appoint 'field, use the insert to statement into this field how can an error?

CodePudding user response:

Haven't people went out, this BBS?

CodePudding user response:

Nobody, I came to ask a question to integral,,,,,,,,,,,,,,,,,

CodePudding user response:

The count quantity first, the remaining, Sheet2
Parentheses, had better not take the field name is this is the SQL statement, if must use, it is best to use Chinese brackets,

CodePudding user response:

Thank me first to go to look at, but inside the field name of the village (house) appoint is fixed, this how to import ACCESS

CodePudding user response:

The

reference 3 floor steking1 response:

count quantity first, the remaining, Sheet2
Had better not take the field name of brackets, this is the SQL statement, if must use, it is best to use Chinese brackets,

How to count? Can write some code?

CodePudding user response:

ACCESS table band () in the fields, such as' village (house) appoint 'field, use the insert to statement into this field how can an error?

SQL statement, the field name in parentheses,

CodePudding user response:

[village (house) appoint] should be ok

CodePudding user response:

And page count,

CodePudding user response:

Copy data count, but the speed will slowly,

CodePudding user response:

Access 2007 export Excel function! Don't have to write programs! Can have a try!

CodePudding user response:

In code is I a exported, so I can judge export record number, if the article 60000, wrote in a Sheet,