Creating Tables from Records

[Jonny]

Having a table with tens of records: Honda, Toyota, Lexus, e.t.c
Required to create a table for each record and to link ID of each table to that record.

Could this be done in a code?

 

[Uncle Gizmo]

It depends a lot on what your current table structure is like. You need to provide a lot more information. As an aside I thought you might like to have a look at at something I created recently which shifts car makes from a table into lots of different Excel spreadsheets, a little bit like the problem you describe, but doing it in Excel:-

Make Excel Sheets From Access Table - Nifty Access

Excel Sheets From Access Table If you've ever faced the challenge of exporting data from Microsoft Access into Excel, you’re not alone! One of the most common requests is to organize data by categories, like exporting car makes into separate Excel sheets or even separate Excel files. I’ve...

www.niftyaccess.com

 

[MajP]

Sure it can be done. You can create tables in Access via code and dynamically add fields. So you can read your current table and break that into multiple tables. Can you explain the purpose?

 

[Pat Hartman]

Why in the world would you want to create a table for each brand? This is spreadsheet thinking. Please tell us what you are trying to do and we'll help you accomplish it without resorting to turning your database into an unmanageable spreadsheet.

 

[Gichukipaul13]

Hello. I want It to be in Microsoft access. As a database. Here is an example

 

[Pat Hartman]

Please try to reformulate your original question.