Table to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not so familiar with this Access VB-programming. But I would like to
following.

There is one table in batabase which contains raw-data, which is imported
from excel. This data should be categorized to other tables based on certain
field, which contains the name of the other table. How is this possible? In
additional this name-field is located as records second field, when first one
is empty. Then the fields under the name-field in raw-data -table sould be
saved to the other table as one record.

[empty ] [Table name]
[device1][device inf.1]
 
I'm not so familiar with this Access VB-programming. But I would like to
following.

There is one table in batabase which contains raw-data, which is imported
from excel. This data should be categorized to other tables based on certain
field, which contains the name of the other table. How is this possible? In
additional this name-field is located as records second field, when first one
is empty. Then the fields under the name-field in raw-data -table sould be
saved to the other table as one record.

[empty ] [Table name]
[device1][device inf.1]
Click to expand...

Only by constructing a SQL string in VBA. The table name in a SQL
query doesn't allow you to use a fieldname or a variable.

Could you explain what you mean by "the fields under the name-field
should be saved... as one record"? Perhaps you could post a larger
sample of the data as it's received, and the desired result.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
It is a document as an Excel-table that should be translated to database's
certain tables simple record. The document contains information about
devices. When device category changes in table there is always first a cell
that contains "text1" and cell under that contains the "category". But if it
is same category's device it doesn't have those two cells. Single device's
Information is arranged following way in xls-file.

[empty ] ["text1" ]
[empty ] ["category" ]
["order code"] ["device description"] [empty] [empty] ["device price"]
["...description2" ]
["...description3 etc."]
[empty ]
["order code 2"] ...

I would like to have sigle device's all information in same Access table's
record following way.

["order code"]["category"]["device description"]["...2"]["...3"]["device
price"]

In additional it should be placed in different table based on category so
that every category of devices has its own table in database. Hope you
understand what mean.
 
Back
Top