foxpro to oracle

[rswamin]

hello friends

i ve some foxpro tables(.dbf files) which i want to convert to oracle. i used sql loader to do this. but since in foxpro the data are seperated by tab i cannot give the position of the data exatly. how can i do it . can any one suggest me a way out.

regards

swamianthan

[jgmagnus]

Possibilities:

Import the FoxPro database into an ACCESS database.
From there you could inport into Oracle effectively.

Access should be able to read all the .dbf files and create an appropriate DB without any problems. See if this works.

- Magnus

[nekelly]

Hello Swamianthan,

You can use:

fields terminated by X'09' or fields terminated by whitespace.

Hope this helps,

Regards,
Noel.

[jgmagnus]

whoops, I misread the original post.
my way would be the LONG route, but you could get the tables exported from access comma-delimited.

NEKELLY is correct.

[TheSlob]

you can export the dbf file to a comma delimited file or you can also use Perl DBI to read the dbf files and insert them into an oracle table.