Importing Data 1

[SkipVought]

I'm using Access 2007.

Importing from an Excel 2007 workbook, using Named Ranges.

Appending to an existing table.

In the process, the First Row Contains Column Headings is checked and grayed out, so that it cannot be changed.

How can I INCHECK this feature?


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

You might want to create a query

SELECT *
FROM MSysIMEXSpecs

See if you can change the StartRow field.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Thanks, Duane. I ended up importing into a new table, but I'll keep that one in my hip pocket.

I'm taking an inventory application I designed in Excel, and moving to Access, where it really belongs. I am way out of my comfort zone, but determined to learn.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

I'm taking an inventory application I designed in Excel, and moving to Access" glad to hear this ;-)

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

I just KNEW that the Hook'D on Access guy would get perverse pleasure, hearing that from a hook'd on Excel guy!

I will, without doubt, be gleaning advice from you and the other Access gurus.

I probably ought to upgrade my "Using Access 97" to a 2007 version, 'ya think? [gray]retorical[/gray]

BTW, when I run your query, I get a message

The Microsoft Office Access database engine cannot find the input table or query 'MSysIMEXSpecs'. Make sure it exists and that its name is spelled correctly.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

I believe if you have saved any import/export specs, the query should work. This is a hidden system table that I thought was also available in 2007.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Here are my query results after saving one import spec.
[tt]
Date DateFourDigit DateLeading Date Decimal Field File Spec Spec Spec Start Text Time
Delim Year Zeros Order Point Separator Type ID Name Type Row Delim Delim
/ 0 0 2
0 21 0 0  :
/ 0 0 2
0 5 1 0 0  :
/ 0 0 2
0 7 11 0 1  :
/ 0 0 2
0 9 111 0 0  :
/ 0 0 2
0 11 1111 0 0  :
/ 0 0 2
0 13 11111 0 1  :
/ 0 0 2
0 15 111111 0 1  :
/ 0 0 2
0 17 1111111 0 1  :
/ 0 0 2
0 19 11111111 0 1  :
[/tt]
What does this mean?

BTW, executing this spec does import the table from Excel.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

I don't mess with this much. I believe these are 9 separate specs. The StartRow of 0 or 1 I think is the check box value.

There is also an msysIMEXColumns table that defines each column in the specification.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Appreciate all your help!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[traingamer]

I usually save a spec with a specific name, like UsersImportSpec. It looks like Access has saved a (default named) spec file for each time you imported or something.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard