From: mls via AccessMonster.com on
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1