Changing data from flat file

[RH]

I created a database containing travel records years ago in a flat file
format. My new format now has a form that allows the user to select from a
drop down list in order to input information. Is there a way to transfer
information from the old flat file to my new format?

 

[Evi]

Yes there is (I was going to stop there but thought that this would be
churlish)

We would need more in formation if you wanted help in how to do it. You
haven't given any clue as to what is in your new format or even what you
mean by a Travel Record. (Michael Palin's journeys through the Amazon or the
cost of Gordon Brown's limo)

Is your new format multiple tables? What was in your old and new format
(including field names and Data types) which you want to put into your new
format? Which bit do you find difficult? Is the drop down list really in a
form or is it just a lookup field in a table.

Evi

 

[mscertified]

Yes, whether you have the data in an Excel spreadsheet or an external text
file, you can import it. When you have your table open, click
'File--GetExternal Data', then the wizard will prompt you. It may be tricky
if you don't have a 1:1 relationship between the old columns and the new.

-Dorian