Re: migrating data process with data type mismatch

One approach might be to create queries against the old data that parses it
into the (normalized) pieces you need for the new data tables. A potential
wrinkle is if, as in your example, you have a old list of values that may
have duplication (there could be more than one person with the same name -
john smith?!). In that case, you'll have to add some kind of identifier
(for temporary use, during the transfer) to the old data so you can match
John Smith#1's other data to the correct John Smith in the new data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Cheese_whiz" <Cheesewhiz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:98E8DD81-D204-407E-BB97-F0F29C6F0082@xxxxxxxxxxxxxxxx
Hi all,

I'm pretty green when it comes to migrating data and action queries and
such.....

I'm trying to get some data out of an old db into a new one. The old
tables
weren't normalized, though, so where my new table stores the fk from
another
table, the old db stores a text entry (like someone's name) and doesn't
have
the second table.

I'm thinking to get the data migrated, I need to rework the old db table
structure. Once it's normalized (like my new db), then maybe I could use
append queries to add the old records. I'm sure I'd have more questions
during the process, but is that the way you have to do it? If not, how do
you deal with a situation like that where the old records in a table
represent what amounts to a query in the new db?

Thanks for any assistance,
CW


.

Relevant Pages

  • Re: Temporary table disappears
    ... John ... > You don't give the version of SQL server, but at a guess you are seeing some ... Check your network documentation. ... And all other nine queries are ...
    (microsoft.public.sqlserver.connect)
  • Re: Query does not include specified expression
    ... Good morning John. ... queries and one table together into another query did the trick. ... "John Spencer" wrote: ... FROM [Individual Associate Statistics] INNER JOIN Errors ...
    (microsoft.public.access.queries)
  • Re: Check boxes in forms to call a query
    ... "John W. Vinson" wrote: ... How can i create a form and call these queries by selecting through check ... Dim db As DAO.Database ...
    (microsoft.public.access.queries)
  • RE: Excel add-in MS Query
    ... Hi John, did you resolve your DClick issue? ... same error when I run an workbook with queries that is loaded to Sharepoint ... > profile folders. ...
    (microsoft.public.excel.programming)
  • Re: I want to delete multiple queries. How Do I do it?
    ... Good point, John; however, some operations require a query rather than SQL, ... One of the techniques I use where queries are required is to have a template ...
    (microsoft.public.access.modulesdaovba)