VB and Excell help

Hi

Can anyone help, I need to get data from access to vb, and then onto a excell chart from there, tried sending a screenshot, but no luck, so if anyone can help, I'll email the screenshot through to you.

Thanx

Koos

If it a once only or infrequent job you can move data from a table or query in Access to Excel by selecting the table or query in the database viewer and selecting File; Save as/Export... from the menu. Export to a new Excel file and then open it in Excel.

If it is a regular task you can write macros or VBA to automate the process.

It is also possible to do what you want from within a VB program but will take more effort to get it working properly. If you still want to do it that way, let us know.

Hey again

I'm using VB6 with service pack 5 and office xp.

Thanx

I am not sure if your version of VB uses the same database engine as Office XP but if not you should be able to use ODBC to get the data from your database.

I only use VB5 and office97 but some one else here should be able to help out.

the engine didn't work, that's y I had to install service pack 5, it works now.If you could just give me some sort of I dea what to do I am really in the darl here.

Thanx