Hi there,

Would really appreciate it if someone could help me out!

I have a linked excel table into Access 2000. I have a field named 'PO number'. In excel, the field type is Text. But in Access, it's coming through as a number. Hence, much of the data is being dropped off.

You can't change data type on linked tables.

Anyway got any ideas?

Thanks!

LMH

I think that Access looks at the first row to determine column data type. It's caused me numerous problems; I convert data to specific datatypes when I use Excel tables.

llkhoutx is right. Excel is very loose about datatypes and allows you to mix datatypes in a column. It's almost impossible to set a datatype in Excel, unlike Access. Using Excel as a data store is asking for trouble, in my opinion.

Thanks both!

I have checked, the first row in the spreadsheet is in text format. I agree with you re excel as datastore. The company I am currently working for is using an excel spreadsheet as a database, and I am trying to force it into access so I can make the whole thing a little easier to report from. Eventually I hope to create the entire thing on access.

Not sure how to get around this problem though. Any other suggestions?

Thanks!