×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

lotus memo to access

lotus memo to access

lotus memo to access

(OP)
what is the best way to transfer a lotus DB to be imported into ms access. I exported all the data from lotus but it makes 3 files. it seems all the memo data goes into a dbt file and i cant open it with access.
help me.

RE: lotus memo to access

The field is in the .dbf file but for a memo field, the dbf just contains a pointer to the data which is stored in the .dbt file. Therefore you only have to open the dbf to get all the data.

Note that when exporting from Approach there are numerous file formats available for selection. You could have used delimited text for example.

If you're still having problems getting data from the dbf in Access, post a question in an Access forum about dBase IV format. Approach exports in standard dBase IV format and beyond that it's an Access issue.

Paul Bent
Northwind IT Systems
http://www.northwindit.co.uk

RE: lotus memo to access

(OP)
i exported from lotus and all the data is there but all the data from the memo filed is blank.
what should i do. it has  nothing to do with access. anyone have any ideas?

RE: lotus memo to access

>>all the data from the memo filed is blank<<

When you open it in which application?

Do you mean you open the Approach (.apr) file, the data is fine, you export from Approach and then open the exported dbf in Approach and the data is missing from the memo field?

Or do you mean when you open it in Access the data is missing?

Paul Bent
Northwind IT Systems
http://www.northwindit.co.uk

RE: lotus memo to access

(OP)
when i export the data from apporach i get everything but the memo data. the memo field is all blank but all the other fields are ok. i dont get it.
but i can see the memo data in the dbf file and i wont import.

RE: lotus memo to access

I can't help you without a clear explanation of the circumstances in which the data is missing. I'm still not clear if it's only missing when you open the dbf in Access.

Can you open the exported dbf in Approach (by selecting file type dBase IV) and see the data in the memo field?

And have you tried my other suggestion to export as delimited text?

Paul Bent
Northwind IT Systems
http://www.northwindit.co.uk

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close