SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Mar 2005
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Angry flat files to microsoft access

    Hi,

    Ive got a project to do where i have to transfer data from a flat file on a pda to microsoft access on the PC. We are using superwaba on the PDA. And i have to have some sort of code in my java application on the PC to import this data and store it in the access database.

    Any ideas?

    Thanks

  2. #2
    SitePoint Addict phpster's Avatar
    Join Date
    Feb 2005
    Location
    Toronto, Canada
    Posts
    374
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    transfer it to CSV format and load that puppy up.
    phpster

    I wish my computer would do what I want it to.
    Not what I tell it to do...

  3. #3
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I really havent tried this before, but i know if you open ACCESS, and click open file.

    1. On the files of type option choose text field or

    2. you could go through ODBC and try text field option and see if it works.

    Afrika


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •