使用ADO对象+SQL语句, 将EXCEL中的数据批量超快速传入ACCESS一例
Set Conn = CreateObject(“ADODB.Connection”)
Conn.Open strConn
strSQL = “insert into [模板] select * From [Excel 12.0;Database=” & ThisWorkbook.FullName & “].[填充KaTeX parse error: Expected 'EOF', got '&' at position 108: …2.0;Database=" &̲ ThisWorkbook.F…A1:CW99999]”" 这是不可以的, 因为最大行超过65536, 会导致只返回65536
'strSQL = “insert into [模板] select * From [Excel 12.0;Database=” & ThisWorkbook.FullName & “].[填充KaTeX parse error: Expected 'EOF', got '&' at position 99: …2.0;Database=" &̲ ThisWorkbook.F…A:CW]”'不可以指定列, 否则在最大行超过65536的时候,只返回65536行
'strSQL = “insert into [模板] select " & 字段头 & " From [Excel 12.0;Database=” & ThisWorkbook.FullName & “].[填充KaTeX parse error: Expected 'EOF', got '&' at position 75: … [模板] select " &̲ 字段头 & " From […A:CW]” '报错文件名找不到, 因为在database前后多了空格