linking...access external data.

[mission2java_78]

I have a huge spreadsheet I use as "Get External Data" in access.

The 2 columns in the excel sheet are numbers....so I would expect access to know that.

So I do this get external data and it creates a link to this excel sheet.
When I update the table in access and go back to excel and look at what it did...it actually stores the numbers as text even though the excel sheet knows the fields are "number" type.

Am I doing something wrong here? Or does access always think its text?

Thanks,
Jon

 

[mission2java_78]

I also cant go into design view and make "Save Changes" since it says it is a linked table...

so how in the world can anyone change a datatype?

 

[dcx693]

Just taking a stab here...

In the Access table design view, what data type does Access assign? If it's not numeric, perhaps it has to do with the column formatting in Excel.

 

[mission2java_78]

I checked that,

but its ok now because I decided to be the hardcore person that I once was and used the excel object model, gives me more control and flexibility.

Access still sucks.

Come on microsoft, get with the program, embedd all of vb6 into access than we'll be happy.

 

[Kevin_S]

Your starting to warm up to Access again... I can feel it

Kev

 

[mission2java_78]

Your starting to warm up to Access again... I can feel it

Kev

hahah real funny kevin!!!

how's work going ?

 

[Pat Hartman]

Jon, you could write the automation code in VB and just call it from Access if that would make you feel better.

 

[mission2java_78]

Jon, you could write the automation code in VB and just call it from Access if that would make you feel better.

Still requires the code in vb...actually the code can be taken word for word from a vb app and stored in an access database app...

So I guess its not so bad...maybe I was still dreary from the ugly guis.

Thanks,
Jon

 

[Kevin_S]

Hey Jon - thought you'd like that!

Works good (besides the fact that we state employees work 40hrs a week for 38hrs pay and have to bank 2 hours a week to be used in the future thanks to budget cuts (with more to come tomorrow by the way))... but enough of my rant on that subject

IT wise - have started to move off of client/server and I am currently being trained on .net framework(utilizing Visual Studio.net platform emphasis in VB and C# not J#) for certification on the MCAD .NET exam. Its kind of funny since as soon as I pass the MCAD exam I'll be headed for private sector work!!! Seriously though... I love the dot net stuff as it is sooo flexible with web services, smart devices, windows forms, etc... Learning a little SOAP too...

All in all doing well... how's things in the 'Hills nowadays?

Kev

Edit:

So I guess its not so bad...maybe I was still dreary from the ugly guis.

Man I NEW you liked Access

 

[mission2java_78]

You like .NET for a reason....

Its expandable, nice guis, and workable...you don't get errors that don't make any sense and make you import objects!!!!

I think the MS folks just test on their local machines and assume everyone has the same setup...

Then again they probably dont test at all!