Convert a CSV into a Microsoft Access database or TAB file

NL__Duo__Edu_edns.png

Foodworks.online Nutrition Labelling allows you to publish your food labelling data to a CSV file. Depending on your requirements you may want to import the label information into Microsoft Access or convert it into a different file type. 

To convert a CSV into a Microsoft Access database (.mdb):

  1. Start by publishing your labelling information in Foodworks.online.
  2. Open Microsoft Access.
  3. Create a new database table or open an existing one.
  4. In the Import and link section, select New data source.
  5. Click From file.
  6. Click Text file.
  7. Select Browse, navigate to the relevant CSV file and double-click it. 
  8.  There are two options for the following steps:
    • If you created your own table: Choose the Append a copy of the records to the table option and select the relevant table.
    • If you did not create a table: Choose the Import the source data into a new table in the current database option. After selecting the option, press OK to continue.
  9. In the new window, select the Delimited option and click Next.
  10. Under the Choose the delimiter that separates your fields: header, select Comma.
  11. Tick the First Row Contains Field Names checkbox.
  12. In the Text Qualifier dropdown select " and click Next.
  13. Click Next again.
  14. Choose No primary key.
  15. Click Next.
  16. In the Import to Table field, insert a table name.
  17. Click Finish.

To convert a CSV into a tab delimited text file (.txt):

  1. Start by publishing your labelling Information in Foodworks.online.
  2. Open the published file in Microsoft Excel.
  3. Select File.
  4. Select Save as.
  5. Change the file format to Tab-delimited Text (.txt).
  6. Click Save.
  7. If you are confronted with a window stating Some features in your workbook might be lost if you save it as Tab-delimited Text (.txt). Do you want to keep using this format? select Yes.

Notes

After completing the steps to import the CSV to Microsoft Access, you can click the option to 'Save import steps'. This will make the process quicker for your next CSV import.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.