Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Data from Access Database in a Workgroup
H!,
Hope someone can help me, I've been trying to figure this out all day. I have a Database on this Path: C:\AssetTracker\Access 2000 \MMH_CIL_RevN_Cnvrtd.mdb /Wrkgrp \\owgn1mmd\mmh_pm2 \Asset_Tracker\CIL2000Compacted.mdw /Nostartup. I want to import the data from an Access 2000 database table to an Excel 2000 worksheet. The database is password protected and part of a workgroup. I've tried the Wizard, Modifying the .dsn file & attempted to do it by creating a VB function. No dice. Thanx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Database query to import from Access to Excel | Excel Discussion (Misc queries) | |||
How to import multiple sheet of excel into Access database to a diffrent tables?? | Excel Discussion (Misc queries) | |||
MS JET database engine error: workgroup information file is missing or opened exclusively by another user | Excel Discussion (Misc queries) | |||
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) |