Exporting files

[DonH]

Let me see if I have this straight. Let's say I have a file that includes the fields NAME and then BP (blood pressure). The BP field is actually a repeating field with every time the person had their BP taken.

Now I want to export this data for import to SQL Server. It appears to me that the best way to do this is to make a new FM file with a NAME and BP field and then import from the original file using the "split" function.

Then export THAT file to a tab file and import the tab file into SQL Server.

Sound right?

[BobWeaver]

Yup.

[andygaunt]

What Bob said