Select problem

M

mi

I have excel-files that contain 4 columns which in the end shall
inserts in another table, the main table, with 12 columns.
I’ve transformed the excel-files to tables.

So now I need to read the new tables and add them to the main table
but depending of the data in the 4 columns I will add different data
in the rest 8 columns.

That is why I’m trying to do select in the table.
The information I’ve got from other people is that’s impossible to do
a select.
If so, how shall I be able to read the data in the tables once were
excel-files?

Maybe it can be done in another way.
Can someone please help me?
I'm using Access 2003.

Thanks in advance.
/Michelle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Access #Error & Excel Pivot 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Link to excel table which has keys in both row and col headers: isthis possible? 0
Import File Information 0
Access Table to Excel Spreadsheet 3
Select file to Import 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top