-2147467259 System resource exceeded

  • Thread starter Thread starter Guy Cohen
  • Start date Start date
G

Guy Cohen

Hi all,

I use VB6,SP6,MDAC_TYP 2.8,ACCESS MDB FILE.

I use these two lines to import an Excel file into a table:

SQL = "SELECT * INTO [" & "table name goes here" & "] FROM [Excel
8.0;DATABASE=" & "file name goes here" & ";HDR=No;IMEX=1].[" & "sheet name
goes here" & "$]"

Call CON.Execute(SQL)

It worked yesterday.
Today it does not...
....With the same excel file/sheet name/mdb file!!!
Please advise.
Guy
 
Hi Guy,

What is the size of your Access database? Access has a limit on a size of
the database. It is 2M. If you have got limit level. then you could try to
compact your database first and try again
 
2M do you mean 2G....

--
Chris Hanscom
MVP (Visual Basic)
http://www.veign.com
--

Val Mazur said:
Hi Guy,

What is the size of your Access database? Access has a limit on a size of
the database. It is 2M. If you have got limit level. then you could try to
compact your database first and try again

--
Val Mazur
Microsoft MVP


Guy Cohen said:
Hi all,

I use VB6,SP6,MDAC_TYP 2.8,ACCESS MDB FILE.

I use these two lines to import an Excel file into a table:

SQL = "SELECT * INTO [" & "table name goes here" & "] FROM [Excel
8.0;DATABASE=" & "file name goes here" & ";HDR=No;IMEX=1].[" & "sheet name
goes here" & "$]"

Call CON.Execute(SQL)

It worked yesterday.
Today it does not...
...With the same excel file/sheet name/mdb file!!!
Please advise.
Guy
Click to expand...
Click to expand...
 
Hi Val

Thank you for the reply.
I made a small program just to check this procedure.
I noticed that on small excel files - the procedure is working fine.
However on large excel files (800K) the RTE show up.
The odd thing is that on my brother' computer both the small file and the
large file can be trasfered to Access !!!

Please kindly advise
Guy


þþ"Val Mazur said:
Hi Guy,

What is the size of your Access database? Access has a limit on a size of
the database. It is 2M. If you have got limit level. then you could try to
compact your database first and try again

--
Val Mazur
Microsoft MVP


Guy Cohen said:
Hi all,

I use VB6,SP6,MDAC_TYP 2.8,ACCESS MDB FILE.

I use these two lines to import an Excel file into a table:

SQL = "SELECT * INTO [" & "table name goes here" & "] FROM [Excel
8.0;DATABASE=" & "file name goes here" & ";HDR=No;IMEX=1].[" & "sheet name
goes here" & "$]"

Call CON.Execute(SQL)

It worked yesterday.
Today it does not...
...With the same excel file/sheet name/mdb file!!!
Please advise.
Guy
Click to expand...
Click to expand...
 
Yes, 2G

--
Val Mazur
Microsoft MVP


Veign said:
2M do you mean 2G....

--
Chris Hanscom
MVP (Visual Basic)
http://www.veign.com
--

Val Mazur said:
Hi Guy,

What is the size of your Access database? Access has a limit on a size of
the database. It is 2M. If you have got limit level. then you could try
to
compact your database first and try again

--
Val Mazur
Microsoft MVP


Guy Cohen said:
Hi all,

I use VB6,SP6,MDAC_TYP 2.8,ACCESS MDB FILE.

I use these two lines to import an Excel file into a table:

SQL = "SELECT * INTO [" & "table name goes here" & "] FROM [Excel
8.0;DATABASE=" & "file name goes here" & ";HDR=No;IMEX=1].[" & "sheet name
goes here" & "$]"

Call CON.Execute(SQL)

It worked yesterday.
Today it does not...
...With the same excel file/sheet name/mdb file!!!
Please advise.
Guy
Click to expand...
Click to expand...
Click to expand...
 
Hi,

Is it the same MDB and same application, which is working on another PC? If
it is working on other PC, then try to find what is the difference between
them. Things to check: MDAC version, Jet OLEDB version

--
Val Mazur
Microsoft MVP


Guy Cohen said:
Hi Val

Thank you for the reply.
I made a small program just to check this procedure.
I noticed that on small excel files - the procedure is working fine.
However on large excel files (800K) the RTE show up.
The odd thing is that on my brother' computer both the small file and the
large file can be trasfered to Access !!!

Please kindly advise
Guy


þþ"Val Mazur said:
Hi Guy,

What is the size of your Access database? Access has a limit on a size of
the database. It is 2M. If you have got limit level. then you could try
to
compact your database first and try again

--
Val Mazur
Microsoft MVP


Guy Cohen said:
Hi all,

I use VB6,SP6,MDAC_TYP 2.8,ACCESS MDB FILE.

I use these two lines to import an Excel file into a table:

SQL = "SELECT * INTO [" & "table name goes here" & "] FROM [Excel
8.0;DATABASE=" & "file name goes here" & ";HDR=No;IMEX=1].[" & "sheet name
goes here" & "$]"

Call CON.Execute(SQL)

It worked yesterday.
Today it does not...
...With the same excel file/sheet name/mdb file!!!
Please advise.
Guy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top