First Row Contains Column Headings - Disabled

My question is related with Access 2007 and the import process of an excel file. During the import wizard appears a check box "First Row Contains Column Headings" which I know exactly what it is.
The point is that is disabled and always checked.

Sponsored Links:

Related Topics

csv import second row contains column headings
I have a process I need to automate.

I have been manually deleting the first row on the CSV since it just contains the CSV title and the second row actually contains column headings

so the checkbox for first row contains column headings is sadly useless to the original file.

any remedy for this? can I delete the first row upon import or something to fix this automatically


csv import second row contains column headings
I have a process I need to automate.

I have been manually deleting the first row on the CSV since it just contains the CSV title and the second row actually contains column headings. so the checkbox for first row contains column headings is sadly useless to the original file.

any remedy for this? can I delete the first row upon import or something to fix this automatically?


Assigning Nulls to a Crosstab Query
I have a question about how to assign nulls within a crosstab query.

Like any other Crosstab query, my CT query generates column headings, row headings and associated data.

I use parameters on a form to generate this CT query. With wide criteria, all column headings get generated. However, with narrow criteria (narrow data range), certain columns/row headings get skipped.

In the final output, I need all rows/columns headings that I get with wide criteria to be present. I use these column headings as fields’ names in a query/macro that help in the generation of my final output (report).

With narrow criteria, I get the error message:
"The Microsoft Jet database engine does not recognize'[tablename.fieldname]' as a valid field name or expression"

My question is how do I force the crosstab query to generate column headings, even if no data is found for them. I would like to assign nulls/zeros to them.


Crosstab column data count
I have a crosstab query with Well Name as row heading , site visit Dates as column headings (formatted as "y"), and averaged water level measurements data as the values. The column headings range from 2004-2010 and some wells have no measurements during some of these years.

I need to create a dataset from the crosstab that shows total number of years for which each well has data. My attempts at changing the column headings and values around to accomplish this have been futile.


Delete first row and Column for excel import
I need to import some data into Access from an Excel sheet, the data was extracted from Business Objects which seems to have an annoying limitation where it adds a blank column and a Blank row into the spreadsheet before adding the data

is there a way to remove a Blank Column and Row before importing the data into Access

as it is now my column headings are on the second row and start in the second column


export report to Excel results in 2 rows of column headers
Here's my issue. I have to export data to excel for uploading to a vendor's system. The vendor required that several of the columns have IDENTICAL headings, and one of the column headings has to contain a % symbol at the end.

I can't do this with exporting a query, so I tried using a report. If I make text boxes for the desired duplicate column headings, it works just fine. The problem is that on row 2 of the exported data, the actual column headings from the query are also exported. Can this be avoided?

Sample of exported data:
Ded % DedAmt | DedAmt
Ded | DedAmt | DedAmt2


Delete first row and Column for excel import
I need to import some data into Access from an Excel sheet, the data was extracted from Business Objects which seems to have an annoying limitation where it adds a blank column and a Blankrow into the spreadsheet before adding the data

is there a way to remove a Blank Column and Row before importing the data into Access

as it is now my column headings are on the second row and start in the second column


crosstab report colum headings
I have a crosstab report based on Duane Hookom's crosstab database. Now, I have a lot of data to report and I am trying to condense it down to as few pages as possible. I can get the data (detail) to be 10 columns wide in the report and still be readable. However, the last two column headings wrap into the next row even though there is plenty (at least it appears that way) of width room left on the page.

I have tried various things, but really do not know how to make it not wrap. I am fairly sure that it has something to do with the subreport I use for the column headings but . . .

Please help a frustrated hacker who has no more hair to pull out!


Access 2003: Import Specification
Is there a way to save in your import specifications, delete the first ROW in a table?
The 2nd row in my data is the column headings, the first row in fact is just a fancy company header I do not need.


Peforming Excel operations via Acces automation
Access 2007 issue, however could relate to earlier versions.

I have an Excel template that has a series of blank rows

Row1 headings
row 2 headings
rows 3 to 30 blank rows
row 34 formulas to sum values in columns =Sum(B4:B33)

Repeated about 5 times further down the worksheet

Access opens the workbook and uses CopyToRecordset to populate Excel from row 4 downwards. Will never be more than 30 rows.

But what I want to do is when the copy has taken place I want to remove blank rows when a row in column B is blank.

What I did was something like

For X = 4 to 250
If Range("B" & X).Value = "" Then
delete the row
End If Next

But could not get it to work


Report from a Crosstab query column heading
My report is not working because of the crosstab query column headings. The crosstab query pulls the last three months of data. It labels the column headings as the date. When I update the crosstab query and try to run the report it is looking for column headings that are no longer there (it drops a month each month I run the report).

How can I get the report to updateautomatically to only include the column headings available in the crosstab query instead of looking for the original ones that the report was designed on?


Display column headings in a combo box
On an Access 2003/XP/2000/97 form, I've created a combo box whose values are populated by a query. I want to see the column headings so that I can differentiate between the various columns. How do I display the column headings in a combo box?


Setting crosstab headings dynamically
I have a crosstab based on a query. Depending on the selection criteria used in the base query the crosstab will generate different column headings, predictable in advance. For example if the user chooses 'Fruit' the crosstab column headings will be 'orange, apple, pear' and if he chooses 'Vegetable' they will be 'onion, potato, carrot'. Can I set these column headings dynamically with VBA so that I can use just one crosstab for all user selections? Creating a different crosstab for each possible user selection and hard-coding the column headings in the crosstab properties isn't a good idea as the fruits might not always be 'orange, apple, pear'.


Odd tabbing through Rows
I have created bunches of simple access DB, and never had this problem, it only has happened in on DB, and the form design was no different than before. Normally in the form in the row I enter figures, tab and go to the next column space in that row, however in the one form when I start off in the first column, I hit tab button and instead of taking me to the next column in the same row, it jumps down to the next column in the row BELOW the row I am working in, in other words it tabs down and to the right. Once I click using the mouse back into the cell I wanted, tabbing through the rest of the columns in that row work fine, its just going from column 1 to 2 that causes a row jump down


Combining Results of Cross Tab Queries
I have two cross tab queries which I am trying to combine into a logical format.

In the first, I have two row headings - employees & type of hours (billable/non-billable). My column headings are the months. The results are the sum of each hour type for the employees.

In the second, I have one row heading, employees. My column heading are the months. The results are the sum of the available employee hours.


add multiple values in crosstab
I have company names in row headings, item names in column headings, and total quantity sold in value. But I want to add price also as value. I want both qty sold and price to be shown against each item.

can I have outcome as below?


Displaying multiple text values in crosstab query
I've created a cross tab query using the query wizard. There are two row headings. Center and Team Description. As far as the headings they relate to different teams. Team 1, Team 2, etc. Now the field used calculated for each row column intersection is Person. I was wondering if there is a was to create a function to display all of the persons on the particular team for that center and team description. I was thinking about trying to do something along the lines of name1, name 2, etc. but all I can get the query to do is output the first or last name. I'm familiar with access but haven't dived into much SQL code at all. I've looked all over this forum and internet and have had no luck


Export Specifics from Excel to Access
I would like to set up a module in Excel that will export certain columns and rows to Access, if they meet a certain criteria. In my spreadsheet, my column headings are in row 30 and my actual data starts in row 33.

In that data, if the values in column AG are greater than 2, I would like to export columns B, C, I, J, Q, R, T, AG, and AH - BQ to an Access Database titled WOWData.


Color change of row based on a column value in Report
In MsAccess 2007,I want each row color to change based on a column value in the report.

For example: Select Name,Age,Salary from table 1 -creates 3 rows.

Name Age Salary
A 15 1000
B 25 2000
c 35 3000

if Salary column is less than 1001,row should be in red- Row 1

if Salary column is less than 2001,row should be in green -Row2

if salary is less than 3001, row should be orange-Row3 .
How to do conditional color formatting of the entire row in Msaccess2007 based on a column value of each row


Conditional formatting of row based on column value in Report
In MsAccess 2007,I want each row color to change based on a column value in the report.

For example: Select Name,Age,Salary from table 1 -creates 3 rows.

Name Age Salary
A 15 1000
B 25 2000
C 35 3000

if Salary column is less than 1001,row should be in red- Row 1

if Salary column is less than 2001,row should be in green -Row2

if salary is less than 3001, row should be orange-Row3 .
How to do conditional color formatting of the entire row in Msaccess2007 based on a column value of each row