Linking Tables Troubles

[TBlatnica]

Hi all,
I am a fairly new User to Access and have been charged at work with making some spreadsheets useful. I have 5 workbooks, with approx. 5-9 wkshts per wkbk, each with anywhere from 200-1200 rows. (CT Scanner Protocol information).

My Idea was to link all of the sheets to a reference excel spreadsheet and then to import that as a linked file to access. The problem is that I cannot change a linked fields property, among other things, and have trouble with some blank fields. i have been working on this for a while, searching the net and am still clueless.

Anybody have any Ideas on what I can do? I can email copies of the "sample" sheet I am using (a condensed version that way I don't goof up the main one, plus it is smaller and easier to work with) to anyone who might be able to help. Or any inout here would be appreciated.

Thanks!

Tony Blatnica

 

[Pat Hartman]

When you import a spreadsheet, Access analyzes the first n rows and determines the datatype from the contents of that sample. If the data isn't consistant, you can try creating tables with the correct format and appending to those tables rather than linking the sheets and then appending.