Exporting Data to Access 2000

Question

Exporting Data to Access 2000

Mapper

Grasshopper

Points: 16
More actions
December 3, 2002 at 9:42 am

#105382

Hi,
I am really new at this and I am trying to query out data from certain dates from a table and then exporting it into Microsoft Access 2000. I am getting confused on how to do this. I am not sure how to write the query or if I even have to create a query. Can I just query out the rows and columns while I am using the DTS Wizard? The help would be greatly appreciated.
Thanks,
Melissa

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 1

Hi Melissa,

If you click on the Wizards tool button in Enterprise Manager, one of the choices you have is Export Data. Select that, then select your data source. Next, set your destination to MS Access. Once you have done this, one of the options you have is to use a query to determine the data to export. Select this option, write your query, and then choose to run immediately or to schedule it for a later time. That should be all there is to it!

hth,

Michael

Michael Weiss

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 2

PS - If you need help writing the query, please provide the particulars of the data you are querying...table name(s), columns, which fields you need to include, date parameters or whatever...

Michael

Michael Weiss

lhughes92 SSC Enthusiast Points: 146 More actions · Answer 3

Melissa,

Create a blank Access database (or you may just use an existing database). In the DTS Wizard (DTS Export Wizard), after you select the source, on the destination screen, choose Microsoft Access from the drop-down list, then browse to the Access database you want the results to be sent to. On the next screen, chose the option to 'Use a query'. On the next screen, the easiest thing to do is select 'Query Builder'. This will walk you through building a query, if you are new to the language. There is an option in this to specify WHERE clause criteria, which is where you would enter your date range. One of the final screens displays the query, then on the next screen, you'll have the option to name the table you want the results stored in. Then you have lots of options for the package, like save, schedule, or just run the package.

Hope this helps!

Lori

Antares686 SSC Guru Points: 125444 More actions · Answer 4

Also, which version of SQL are you running. From what I can remember here you have 7 cannot understand the Access 2000 format and can only write to 97, I am not sure if this changes with MDAC install or Service Pack.

don1941 SSCarpal Tunnel Points: 4183 More actions · Answer 5

When you create your task, you can just hard code your dates in the query. If this is a monthly task, it has the drawback of needing to be edited every month of new dates.

Mapper Grasshopper Points: 16 More actions · Answer 6

Hi,

Thanks everyone for your help. I really appreciate it.

Melissa