| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Downloading Access database table into Excel (VB)
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Downloading Access database table into Excel (VB)
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Downloading Access database table into Excel (VB)
Hi Sheeloo
I get a "Compile Error" "User-defined type not defined" on the first Dim statement for cnt "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Downloading Access database table into Excel (VB)
See also
http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Downloading Access database table into Excel (VB)
Ron
I appreciate the help! I will work with your download example and try to understand the logic but it look like it will do the trick. Again, thanks a lot. Steve "Ron de Bruin" wrote: See also http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table connected to an Access Database Data Source | Excel Discussion (Misc queries) | |||
| Creating pivot table from Access database | Excel Discussion (Misc queries) | |||
| Do I need Excel or Access for my database needs? | Excel Discussion (Misc queries) | |||
| vlookup and Access Database Table | Excel Discussion (Misc queries) | |||
| Pivot Table against an Access Database | Excel Discussion (Misc queries) | |||
Linear Mode
