Retrieving data from Excel and store it into string variable

  • Thread starter Thread starter marsulein
  • Start date Start date
M

marsulein

Hi NickHK,

I have just get it working. The problem lies with the spreadsheet
itself. You see, there are 900 records in there, and I am not the one
that wrote all those data in. The point is, the data entry person did
some mistakes, there are some fields which is emptied.

It is also my mistakes not to check for empty fields, I will build in
that function after this.

Just wanna say thanx for your help along the way.

And before I go, though that 2 method of creating RecordSet are
different, they have the same result. It's like doing

Dim MyName as String
Dim MyNick$

Regards,
marsulein
 
marsulein,
Whilst the 2 methods achieve the same goal, they are not the same as you
indicate below.
With CreateObject you are using late binding, but Set xx = New you are using
early binding.

If you have a reference to ADO library, you may as well use it and not
suffer the late binding resolution time.

NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO retrieval from close workbook-data type issue 2
Retrieving data from Excel and store it into string variable 1
Retrieving data from Excel and store it into string variable 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
SQL not importing records from ACCDB 2
CSV Help needed 4
Retrieving data from Excel and store it into string variable 1
How to copy data from an excel cell into a field in access table 0

Back
Top