Access & Excel 2007 - Help Needed

Sandy · Feb 17, 2009

I have an access database with 538000 records. I have Excel 2007 which can
handle 1M rows of data. I tried exporting the access data to excel but the
clipboard can only handle 65000 rows of data.

I can write code in excel but have not done so in access. Is there a way to
get my access data into excel using a macro or some other method?

Thanks,

Sandy

Gina Whipp · Feb 17, 2009

Sandy,

Have you tried the TransferSpeadsheet method?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Sandy · Feb 17, 2009

I have not and I do not know what that is. Can you provide more info?

Thanks

Gina Whipp · Feb 17, 2009

Sandy,

http://msdn.microsoft.com/en-us/library/aa220766.aspx OR you can go to help
and type TransferSpreadsheet, I do not know IF anything changed for Access
2007 though I doubt it.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm