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. Select the External Data tab. 
  5. In the Import and Link section, select New Data Source.
    Screenshot_2023-04-28_at_11.42.29_am.png
  6. Click From file and select Text file.
  7. In the new window that opens, select Browse, navigate to the relevant CSV file and double-click it. 
  8. Select the option Import the source data into a new table in the current database. After selecting this option, click OK to continue.
  9. On the Import Text Wizard modal, select the Delimited option and click Next.
  10. Under the section Choose the delimiter that separates your fields 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 and click Next.
  15. In the Import to Table field, insert a table name or keep the name provided.
  16. Click Finish.
  17. You will be prompted to save these import steps, you can choose to do so, or simply select Close

Your new table will be visible on the side navigation pane. Double click to open it. 

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?
5 out of 5 found this helpful

Comments

0 comments

Please sign in to leave a comment.