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):
- Start by publishing your labelling information in Foodworks.online.
- Open Microsoft Access.
- Create a new database table or open an existing one.
- In the Import and link section, select New data source.
- Click From file.
- Click Text file.
- Select Browse, navigate to the relevant CSV file and double-click it.
- 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.
- In the new window, select the Delimited option and click Next.
- Under the Choose the delimiter that separates your fields: header, select Comma.
- Tick the First Row Contains Field Names checkbox.
- In the Text Qualifier dropdown select " and click Next.
- Click Next again.
- Choose No primary key.
- Click Next.
- In the Import to Table field, insert a table name.
- Click Finish.
To convert a CSV into a tab delimited text file (.txt):
- Start by publishing your labelling Information in Foodworks.online.
- Open the published file in Microsoft Excel.
- Select File.
- Select Save as.
- Change the file format to Tab-delimited Text (.txt).
- Click Save.
- 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.
Comments
Please sign in to leave a comment.