Knowledgebase: Databases
Convert a Microsoft Excel file to a Microsoft Access products database
Posted by Matt Marler on 24 March 2010 11:09 AM
If you have your products in an Excel spreadsheet, you can convert this to an Access database to be used for the Cart32 products database.

*Excel spreadsheet format requirements:
- The columns in the list are the fields in the database.
- The column labels in the list are the field names in the database.
- Each row in the list is a record in the database.

To import a Microsoft Excel file in Microsoft Access 2.0

1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.

2. Start Microsoft Access 2.0 and open the database you want to import the Microsoft Excel information into.

3. On the File menu, click Import. From the Import dialog box, choose the appropriate version of Microsoft Excel that you are importing and click the OK button. Microsoft Excel 7.0 files are not on this list. If you are importing a version 7.0 file, choose the Microsoft Excel 5.0 option.

At this point options such as whether to append to an existing table or create a new table may be selected.

To import a Microsoft Excel file in Microsoft Access 7.0

1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.

2. Start Microsoft Access 7.0 and open the database you want to import the Microsoft Excel information into.

3. On the File menu, click Get External Data and then click Import.

4. From the import dialog box, choose Microsoft Excel (*.xls) for the Files Of Type option.
This will display only the Microsoft Excel files.

5. Find the desired file and click the Import button.

The Import Spreadsheet Wizard appears and allows you to choose options specific to the file.

Connecting the database to Cart32
Once these steps are completed, you can upload the Access database file to your Cart32 directory and follow the standard product database setup procedures located here.
(27 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: