Unable to Import From Access .txt Export #874

Activity

1. chrisjlocke commented on Nov 19, 2016

   

   chrisjlocke

   on Nov 19, 2016

   Member

   More actions

   What's line 1 in the file, or could you email it to me?
2. JamesJoey commented on Nov 19, 2016

   

   JamesJoey

   on Nov 19, 2016

   Last edited by JamesJoey

   Author

   More actions

   This is line 1 in the txt file: 33,"Purchase",6/29/1998 0:00:00,$12312.00
   Line 1 is the first row and "33" is the record ID of the first record.
   Also, how come the import .csv grayed out?
3. chrisjlocke commented on Nov 19, 2016

   

   chrisjlocke

   on Nov 19, 2016

   Last edited by chrisjlocke

   Member

   More actions

   Just to confirm, did you import this using the 'File | Import | Table from SQL File' ?
   If so, did you then get a screen showing a sample of your data? eg:

   

   'File | Import | Database from SQL file' wouldn't work, as I assume would give the above error...
   You need to create your blank database first, and create the fields the data is going to be imported into.
   The export from Access is just the data, and not the schema on how to build a database table.

   👍React with 👍1Reacted by JamesJoey
4. JamesJoey commented on Nov 19, 2016

   

   JamesJoey

   on Nov 19, 2016

   Author

   More actions

   That was it.
   I needed to create a new db with the fields to import to.

   Thanks much,
   James
5. chrisjlocke commented on Nov 19, 2016

   

   chrisjlocke

   on Nov 19, 2016

   Member

   More actions

   \o/

   No problem. Guess its not that intuitive if you're used to other systems. Something else to add to the wiki... ;) Glad you got it in the end. :)

   😄React with 😄1Reacted by Justin Clift
6. chrisjlocke

   closed this as completedon Nov 19, 2016