Problems Linking Excel Tables into Access

[traversd]

Hi,

I have recently tried to link two sheets from an Excel file into access so that I can use the data for queries. The first sheet imported fine with the first row as headings. However when I try to import the second sheet with the first row as headings, the table creats with the correct number of records, but the table is blank. When I import without headings on the second sheetit works. But I really want the headings on both as they may not always be the same tables....anyone any ideas ?

 

[Corticus]

Hi,

What kind of data do you have in the sheet that's not importing versus what's in the sheet that's correctly importing?

Also, what differences might there be in field names?

Corticus

 

[traversd]

Hi.

The sheets are pretty much the same. The query being run is just to compare mismatches between the two sheets.

 

[Ziggy]

[No message]

 

[Ziggy]

That happens to me sometimes, is there any special formatting in the header?

When this happens to me, I select the whole sheet then copy and paste(SPECIAL) Values only to a new work book just to see if it imports. If it does then you need to look at the formats and data types, basically try different things to narrow down the problem

 

[Corticus]

This is a longshot, but,

Since one table works and the other doesn't, I don't think there's anything to do to the table. I would create another table with the same fields and paste the data over fromthe one you can't export.

Other than that, I'n not sure
Sorry, that's a strange one,
Corticus

 

[Anne Troy]

I'm not liking the headers in your second table. What happens if you change all the headers (save to a different name first, please) to Field1, Field2, etc.?