How to export foxpro db to access mdb

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan48 - 27 Jul 2005 17:01 GMT

I am not family with foxpro. I have tried to export foxpro db to xls before,
i found a field is minutes format. all this fields data cannot export to xls.
then how can i export foxpro data completely to access mdb. Thank you very
much

Reply to this Message

Cindy Winegarden - 27 Jul 2005 20:55 GMT

Hi Alan,

Earlier versions of FoxPro only had a Date data type but DateTime was added
in later versions. Also, FoxPro allows an "empty" date, that is, it's not
Null and it doesn't have a value. When you export the data you might have
problems when going from a Date to a DateTime data type.

Are you seeing all of your date fields with minutes only, or only a few? If
only a few then those are probably empty dates, and you are getting all the
data.

Signature

Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

>I am not family with foxpro. I have tried to export foxpro db to xls
>before,
> i found a field is minutes format. all this fields data cannot export to
> xls.
> then how can i export foxpro data completely to access mdb. Thank you very
> much

Reply to this Message

Alan48 - 28 Jul 2005 03:33 GMT

I am quite lucky i can withdraw all date data from foxpro but not minutes. I
would like to know what export format can withdraw all data from foxpro. like
*.csv, *.xls... thanks

> Hi Alan,
>
[quoted text clipped - 13 lines]
> > then how can i export foxpro data completely to access mdb. Thank you very
> > much

Reply to this Message

Cindy Winegarden - 28 Jul 2005 03:50 GMT

Hi Alan,

I'm not sure what you're after, but FoxPro Date data types are just that - a
date. There is no time associated with a Date data type. Later versions of
FoxPro tables may have a DateTime data type, which will have minutes
attached, and the minutes may or may not be zeroes.

Even if you export to CSV or XLS if you have a Date data type then all
you'll get is a date.

Signature

Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

>I am quite lucky i can withdraw all date data from foxpro but not minutes.
>I
[quoted text clipped - 24 lines]
>> > very
>> > much

Reply to this Message

Alan48 - 28 Jul 2005 04:15 GMT

Sorry, I think i gave you a wrong message from my question. I told you the
problem of "minutes" format. it likes "notes" not a time format. It is a
description format. i would like to say an apologize to you, thank you. I
want to export is this notes format.

> Hi Alan,
>
[quoted text clipped - 34 lines]
> >> > very
> >> > much

Reply to this Message

Cindy Winegarden - 28 Jul 2005 20:45 GMT

Hi Alan,

Are you perhaps referring to "Memo" fields? Memo fields are for storing
large amounts of free text. If you export a Fox table to Excel you'll get
the value "Memo" and not the text of the memo field. When exporting to a CSV
file you don't even get the "Memo" placeholder.

However, when you link to the Fox table in Microsoft Access you'll get the
whole text of the memo. However, to do this you will need to use ODBC.

Signature

Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

> Sorry, I think i gave you a wrong message from my question. I told you the
> problem of "minutes" format. it likes "notes" not a time format. It is a
> description format. i would like to say an apologize to you, thank you. I
> want to export is this notes format.

Reply to this Message

Alan48 - 29 Jul 2005 03:12 GMT

Sorry, then would you teach me how to use ODBC export all data completely
from foxpro to access. thank you

> Hi Alan,
>
[quoted text clipped - 10 lines]
> > description format. i would like to say an apologize to you, thank you. I
> > want to export is this notes format.

Reply to this Message

Cindy Winegarden - 30 Jul 2005 06:55 GMT

Hi Alan,

You don't actually "export" the data from FoxPro, you "import" it into
Access. Open Access and create a new blank database. Use File > Get External
Data > Link and then scroll to the bottom of the data type choices to ODBC
and go from there. It will take you through the steps of creating an ODBC
data source and then allow you to choose any/all tables to link to.

Signature

Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

> Sorry, then would you teach me how to use ODBC export all data completely
> from foxpro to access. thank you
[quoted text clipped - 18 lines]
>> > I
>> > want to export is this notes format.

Reply to this Message