On Thu, 20 Mar 2008 03:03:59 +0000, Tom wrote
(in article <zukEj.6881$i54.3543@[EMAIL PROTECTED]
>):
>
> "Brian Paul Ehni" <behni@[EMAIL PROTECTED]
> wrote in message
> news:C4073CF1.A56F3%behni@[EMAIL PROTECTED]
>> On 3/19/08 9:31 PM, in article m0kEj.6877$i54.3456@[EMAIL PROTECTED]
"Tom"
>>>
>>> He doesn't need to manipulate the data just view it. Do you think
>>> FileMakerPro is the way to go?
>>
>> FileMakerPro may not be able to open Access databases...
>>
>
> I'll check in the Access newsgroup.
You can open Access databases, but not directly. Here are the notes I
made
at the time I did this:
To transfer files from Access to another database (on another computer):
Ex****t each table/query* in turn as text (delimited) to somewhere easy to
locate.
Ex****t to File: give name (8 characters max)
Ex****t Text Options: Store Field Name in First Row
Open each file in turn in Excel and text im****t wizard will start:
Choose delimited text
Fields separated by comma
General for column headings
Check all rows are present and nothing looks odd (eg dates can change)
Then save as CSV (Macintosh)
When all done, copy all these .csv files to external storage
Then in Filemaker
Open CSV files (direct from USB stick), and select first row as field
names.
Save as xxx Converted in appropriate folder.
Check all rows are present
*Where a query is a result of an Expression needing an entry such as
[a-z],
the above will not work. Open the query, copy and paste into Excel then
save
as above. You will not get the text im****t wizard in that case
Hope this helps. Incidentally, if your friend is thinking of going the
Filemaker route, it is probably worth buying an older version on eBay -
that's what I did and it was about half the price of the current version,
and
I really didn't need the bang up-to-date one.
--
Sally in Shrop****re, UK
<http://www.freerice.com/index.php>
Give free rice to hungry people by playing a simple word game
|
