LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default obtaining data from Access

I would like to include VBA code that will import data
from an Access table. The data would come from an Access
table after one of the columns was filtered and sorted.
This can be done easily manually using 'get external
data', however using the code the macro recorder provides
yields all results from the table instead of only the ones
from the filtered column. Is there an easier way to do
this like calling upon an Access object or something?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
obtaining data from a table Chau Excel Worksheet Functions 1 February 24th 10 12:24 AM
Problems Obtaining Data ImbImb Excel Discussion (Misc queries) 1 May 26th 09 06:29 PM
Obtaining access to protected files you dont know password for Heidi[_2_] Excel Discussion (Misc queries) 1 January 10th 08 04:49 PM
obtaining data from a list vencopbrass Excel Discussion (Misc queries) 4 February 24th 06 03:45 PM
Obtaining a single Access record from Excel input travis Links and Linking in Excel 5 November 23rd 05 09:02 AM


All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"