Reading xlsx file-- examples please

  • Thread starter mls via AccessMonster.com
  • Start date
M

mls via AccessMonster.com

Hi All, I am looking for some example to read .xlsx file which has about 45
columns and 150 rows using VBA. I need to specify the data type for each
variable in my code as my age variable has character values and it is
importing as missing if I use transferspreadsheet. Also my headers are spread
in 2 rows which looks little tricky.

Thanks
 

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

Reading xlsx using fso -logic.. 7
Large Excel 2008 .xlsx file behaviour with Vista 3
Very large database (600k rows, 40 columns in xlsx) 4
Reading csv file and parsing comma delimited values in Array 1
Changing xlsx file to zip and deleting a file 0
multiple columns into one column and autofill(?) question 1
Currency symbol issues with xlsx file format 5
Shared Workbooks & Code 1

Top