Help!!
I've been building a database for my company, have spent weeks on it so far. The data is taken from various excell sheets that are already in use, put into a main excell sheet, and then linked tables are used to put the info into access. This was the only way of doing it.
I've been having much trouble with the access side of things. I find the whole system really frustrating esp using linked tables as nothing can be changed!!
Ive had a lot of trouble with things not being able to be read in access. eg, our revision numbers can be A, B, C, or 1, 2, 3, etc. If I define these as a number it comes up with an error so I've had to define them as text. There's nothing I can do about this its because we use part numbers from different customers.
Anyway finally thought I'd got it sorted. I'm now having to do text to columns macros within the excell file to make sure that any numbers are formatted as text, etc, etc, so that access can read it.
Then got my boss coming to look at it tomorrow morning, and hey presto run it today and I'm getting 'numeric field overflow' error!!
I've read a few posts on here but most seem to suggest changing the field type (which I can't do as its a linked table) or that there are text/ numeric conflicts (which I've tried to get rid of as much as possible but some examples, eg, revision numbers I can't do anything about)
Can anyone tell me what specifically causes it??
Can anyone help!!
(ps I'm off home in a min so won't be able to answer any questions till 8am tomorrow)
(pps it doesn't do it in every query, and oddly the one it does it in is the one with the least date/ fields, etc)
Cath
I've been building a database for my company, have spent weeks on it so far. The data is taken from various excell sheets that are already in use, put into a main excell sheet, and then linked tables are used to put the info into access. This was the only way of doing it.
I've been having much trouble with the access side of things. I find the whole system really frustrating esp using linked tables as nothing can be changed!!
Ive had a lot of trouble with things not being able to be read in access. eg, our revision numbers can be A, B, C, or 1, 2, 3, etc. If I define these as a number it comes up with an error so I've had to define them as text. There's nothing I can do about this its because we use part numbers from different customers.
Anyway finally thought I'd got it sorted. I'm now having to do text to columns macros within the excell file to make sure that any numbers are formatted as text, etc, etc, so that access can read it.
Then got my boss coming to look at it tomorrow morning, and hey presto run it today and I'm getting 'numeric field overflow' error!!
I've read a few posts on here but most seem to suggest changing the field type (which I can't do as its a linked table) or that there are text/ numeric conflicts (which I've tried to get rid of as much as possible but some examples, eg, revision numbers I can't do anything about)
Can anyone tell me what specifically causes it??
Can anyone help!!
(ps I'm off home in a min so won't be able to answer any questions till 8am tomorrow)
(pps it doesn't do it in every query, and oddly the one it does it in is the one with the least date/ fields, etc)
Cath
