Thread
:
Downloading Access database table into Excel (VB)
View Single Post
#
6
Posted to microsoft.public.excel.misc
Steve
external usenet poster
Posts: 1,814
Downloading Access database table into Excel (VB)
Sheeloo
Thanks for help but I have a question re "wsBlad" in your code. What is this?
For lnCount = 0 To lnNumberOfField - 1
wsBlad.Cells(1, lnCount + 1).Value = rst.Fields(lnCount).Name
Next lnCount
Thanks again
Steve
"Sheeloo" wrote:
Visit
http://www.ozgrid.com/forum/showthread.php?t=11285
--
- Sheeloo
PS: You may send your file to me at
after
removing XXXYYY.
"Steve" wrote:
I don't have any familiarity with Access databases but have one that I need
to download and manipulate in Excel using Macros or
VB
within excel. Can
somone please help me with Excel
VB
code that will export a table from Access
to Excel.
Database name = Pressing.mdb (2000 file format)
Table name = Used Felt
Columns= "Mill Code", "Machine" and "Position" etc.
Thanks a bunch
Steve
Reply With Quote
Steve
View Public Profile
Find all posts by Steve