import a text file to a table

[polyubi]

Could any people tell me how to import a text file from the second line to a table? because 1st line contains useless word.
thanks in advance!!

 

[vbaInet]

Use the Import Wizard and follow the instructions. There's a part that will ask you whether your file contains Headings or not.

 

[polyubi]

the heading is on the second line. and I need vba code to del with this kinda situations

 

[vbaInet]

I'm sure what is on the first line can be deleted because I would imagine it's a "super" heading. Get rid of it and make the heading the first line.

If you want to perform a more advanced kind of import then you would need to look into two things (using vba):

1. File Scripting Object or Reading from Excel file using vba
2. INSERT into statement plus Docmd.Runsql

 

[polyubi]

Thanks VbaInet. Yes it is correct. But I am no good at vba code therefore need help.

 

[ChrisO]

In order to help with a VBA solution, people will need two things: -

1. The actual text file or at least the top 10 or so lines.
2. The table structure and the correlation between the fields in the table and the ‘fields’ in the text file.