How to export foxpro db to access mdb

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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,

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.
 
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,

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.
 
Sorry, then would you teach me how to use ODBC export all data completely
from foxpro to access. thank you
 
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.
 
Back
Top