hi is there someone that can give me some hints on how to create excel file using data from my ms access database..because i haven't seen one in the net maybe someone might help me here..i would appreciate some hints or tutorials..:D thanks a lot...
mcdczzz
4
Newbie Poster
Recommended Answers
Jump to PostIn Excel when you take the "File ... Open" menu option you can change the file type to Access database. The next step is to select a data source such as a table or query. Then you see the database table in Excel. Very easy.
Jump to PostNot really exporting; you don't necessarily have to do anything in Access. So I guess it is more like importing your Access data into Excel.
Try it:
In Excel, open a file.
A file selection dialog appears.
Change the file type to "Access Databases".
Select the Access database you want.
…
All 5 Replies
SalmiSoft
102
Junior Poster
mcdczzz
4
Newbie Poster
SalmiSoft
102
Junior Poster
Stuugie
commented:
Exactly right!
+5
e.pol
0
Newbie Poster
Stuugie
50
Marketing Strategist
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.