|
|
get works database into Access
Greetings,
I was provided a works database (.wdb) that I need to get into
Access 2000 so I can use the data. I do NOT have works so
I can export the data in comma delimited format.
anybody have any ideas on how to do this ?
thanks,
Darryl
|
|
0
|
|
|
|
Reply
|
Darryl
|
11/26/2003 4:19:30 PM |
|
On Wed, 26 Nov 2003 10:19:30 -0600, "Darryl" <darryl@osborne-ind.com>
wrote:
>Greetings,
>I was provided a works database (.wdb) that I need to get into
>Access 2000 so I can use the data. I do NOT have works so
>I can export the data in comma delimited format.
>
>anybody have any ideas on how to do this ?
Try opening the Works database in Excel, and linking or importing from
there.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
0
|
|
|
|
Reply
|
John
|
11/26/2003 5:46:29 PM
|
|
I think Excel can import that data.
So, just import into Excel, and then from there you can easily import into
access.
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
NoooSPAmkallal@msn.com
http://www.attcanada.net/~kallal.msn
|
|
0
|
|
|
|
Reply
|
Albert
|
11/26/2003 5:46:39 PM
|
|
I have the same problem - tried to open with Excel then
tried to import external data and "could not open or read
this query file. Either the file has been damaged or the
format is not valid"
>-----Original Message-----
>On Wed, 26 Nov 2003 10:19:30 -0600, "Darryl"
<darryl@osborne-ind.com>
>wrote:
>
>>Greetings,
>>I was provided a works database (.wdb) that I need to
get into
>>Access 2000 so I can use the data. I do NOT have works
so
>>I can export the data in comma delimited format.
>>
>>anybody have any ideas on how to do this ?
>
>Try opening the Works database in Excel, and linking or
importing from
>there.
>
>
> John W. Vinson[MVP]
> Come for live chats every Tuesday and Thursday
>http://go.compuserve.com/msdevapps?loc=us&access=public
>.
>
|
|
0
|
|
|
|
Reply
|
LU
|
11/27/2003 8:04:55 PM
|
|
Hi Darryl
Open the Works db as a text file and save as a text file. This will delineate it
Open Excel in design view, then File, get external data, and work throught the wizard that will apear
Dave
----- Darryl wrote: ----
Greetings
I was provided a works database (.wdb) that I need to get int
Access 2000 so I can use the data. I do NOT have works s
I can export the data in comma delimited format
anybody have any ideas on how to do this
thanks
Darry
|
|
0
|
|
|
|
Reply
|
Utf
|
12/2/2003 7:11:10 PM
|
|
|
4 Replies
123 Views
(page loaded in 0.101 seconds)
|
|
|
|
|
|
|
|
|