Find fields that will truncate importing from Excel to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting an Excel (2003) file into Access (2003). I want some of the
fields to be smaller than what the Excel data is, but I want to find the
records (either in Excel or Access) that will or has truncated in order to
alert the users. Is there a way I can do this? Thanks for helping!
 
Perhaps another approach?

If you open Access and import data from Excel, you can import into an
already-defined table structure. I consider this a "temporary" table
because it's essentially a copy of Excel data pushed into an Access table
without any consideration of format, normalization, etc.

Then you can create your "permanent" Access tables that ARE well-normalized,
are sized and typed as they need to be.

Finally, you can create queries that "parse" the data from your "temporary"
table into your "permanent" tables.

When you are done with this process, a simple query (or several) can compare
the length of the data in your permanent table(s) with the corresponding
length of data in your "temporary" table (fields).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thank-you, Thank-you! I don't know how to compare the lengths in a query (I
don't know the syntax for that), but I just compared the fields and that
worked like a charm! Exactly what I wanted and I can't thank you enough. I
had done a lot of research on the net for this problem and couldn't find any
help.
Again, many thanks!
 
Create a new query in design view.

Add a table, add a field.

Now modify the field to read something like:

MyFieldLength: Len([MyField])

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks for this info Jeff! (I didn't see this until just now. I'm very new
(first time) at using this discussion group and thought I would get e-mail
when response came in.
Please know how much help you've been! Thanks, Sherry

Jeff Boyce said:
Create a new query in design view.

Add a table, add a field.

Now modify the field to read something like:

MyFieldLength: Len([MyField])

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

SherryScrapDog said:
Thank-you, Thank-you! I don't know how to compare the lengths in a query
(I
don't know the syntax for that), but I just compared the fields and that
worked like a charm! Exactly what I wanted and I can't thank you enough.
I
had done a lot of research on the net for this problem and couldn't find
any
help.
Again, many thanks!
Click to expand...
Click to expand...
 
Back
Top