Import from Excel 2007 to Access 2007

[Chris LNG]

Hi,

I thought this would be simple, but that was 4 hours ago.

I need to do a standard import from Excel 2007 to Access 2007 with one exception: The data is by column and not by row. The first column contains the field names and the second column is the corresponding data that I need to import. It has to be this way because I'm using Excel mobile on a handheld device for users to input field data and the cursor movement is 'down' on Enter in Excel mobile. Any help would be greatly appreciated and would likely prevent an aneurysm.

Thanks,
Chris

[June7]

Nothing standard about that import.

Here is one example of programmatically importing data from Excel http://forums.aspfree.com/microsoft-...et-413493.html

[Chris LNG]

June7,

Thanks for the info. I have the data in Access and now I need to manipulate it but I am still unable to get this to work and unable to locate an example of my situation. The examples seem to be for situations more difficult than mine, but I can't develop a solution. Access is much deeper and way more complicated than the typical user thinks. This is exactly what I need to solve:

Table1 - Access table from import of excel 2007 named range without column headings.

Field1

101

102

103

104

Table2 - Existing Access table to transfer data into with column headings already defined.

Flow	Temp	Press	Rate
101	102	103	104

Each time I execute I need the newly updated Table1 Field1 to be a new record in Table2. Data in Table1 Field1 will be overwritten each time user clicks a button in Access after user has uploaded new data from field device into Excel spreadsheet. That's phase 2. Right now I just need to get from Table1 to Table2. Also, are there any really good web-based Access classes that you would recommend?

Thank you,
Chris LNG

[June7]

How did you import the data? It is possible with VBA code to import directly to Table2 each record. Does the Table1 import include the field with the field names? Maybe a CROSSTAB query will transpose the record. Then use the CROSSTAB as source of records to insert into Table2 with an INSERT SELECT sql acton.

Or you can use Excel to first transpose the data so it is in proper structure with field names across.

Never took any web 'classes'. Have heard Lynda.com is fairly good but it is a fee-based resource. An introductory book would be probably be just as effective.

Review https://www.accessforums.net/program...tml#post180737