Recent content by SkiGeek

Thank you!!!! Works Great!

I knew I was going to get that response. I should of explained in a little more detail. This is just a utility function that is ran once after a mass upload of data. the data is uploaded from an excel sheet to a temp table I then go through and Append the columns i need to the appropriate...

I have been struggling with this for a while now and cant seem to get this update to work. I have a table that holds a project id, a line ID and then the percent allocation to each service line. I am trying to calculate the percent allocation based on the number of repeat project id's IE: 1...

Found a solution, well a good description of the problem http://www.dailydoseofexcel.com/archives/2004/06/03/external-data-mixed-data-types/ But does anyone have any other solutions?

A bit of a premature post. Found a solution, well a good description of the problem http://www.dailydoseofexcel.com/archives/2004/06/03/external-data-mixed-data-types/ But does anyone have any other solutions?

Sounds Like we think alike. I also set up a form to automate the import and am recieving the same problem. From what I can tell it is because the transferspreadsheet command uses the first few rows to determine the column type. In your case if the first few rows are all numbers in a specific...

The blank lines show up before your data because the table is most likely sorted in increasing order. Blanks just come first. I have had the same problem. I bypassed it without setting a range (I didnt want my user to have to do this) by importing the data to a tempTable and then I Delete all...

Hello all, I'm using some vba to transfer an excel spreadsheet into an existing table. Is there a way to stop the transferspreadsheet command from automatically choosing the datatype? I think this is the problem because when the first few rows of a specific column are blank I get Type...