transfer data using a macro

[jmj]

I am using a macro to transfer text the data from a spreadsheet into a new table. The spreadsheet can range from 10-70 columns. (It starts as a .dlm file which is an ascii delimited file. Since access doesn't recognice .dlm I save it as a .txt or .xls)
The table made with data does not match the original spreadsheet. It seems to drop some of the columns, then the labels don't match up with the orignal data.

If I import it manually, it is fine. Has anyone had this problem. Any ideas on how to fix it?
Thanks,
J

 

[KenReay]

Hi

"ascii delimited file" what do you mean by this?, do you mean comma seperated eg

var, var2, var3

if yes, Access does handle importing such files directly

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK