TXT imports ACCESS into the specified field 15

How to write an asp read. The content in txt is stored in the database.

The content is 2 lines.

Database table: test field, id (autonumber), name(text 50), p bianma (text 50).

Test environment win2k by [grkz]seandim i,nums,ho,hor

dim id,names,bianma

names=""

i=0nums=3

The number of records to be read (the content is 3 rows, when nums=0, the number of records read is not limited) set ho="")

set hor=

do while <>true

bianma=

Here's the insertion database, write it yourself

if nums<>0 then

i=i+1if i>=nums then exit doend if

loop : set hor=nothingset ho=nothing

1. First of all, the text file should be a comma-separated or tab-separated file before it can be imported;

2. Then switch to access;

3. Open a new or existing database in Access;

4. Click the Table tab of the Database window.

5. Point to the "Get External Data" command in the "File" menu, and then click "Import".

6. Click the "Text File" command in the "File Type" box;

7. In the File Name box, enter the name of the text file you want to import.

8. Click the "Import" command;

9. Follow the instructions in the Import Text Wizard dialog box.

Can't you record the data in excel and pour it in?

You can try to open this text file with excel first, and save it as an xls file. Then import the XLS file into Access, which is probably the easiest thing to do.

Direct import, the focus is to set the delimiter, pay attention to the will, set as the separator, there should be no problem, try it.

I use access to open this text directly.,It's okay.,There's no gibberish you said.,You see if there's any illegal characters in the txt document.,It's definitely okay.,Hehe.,I wish you success.。

You first copy the text, copy the 2 columns, and then create 2 fields in access, select both fields with the mouse, and then paste, you can try to do it.

Or you paste it into ** first, and then use ** to derive access

Regular expression matching is used, and multiple data insertions can be supported at the same time.

One word, copy and paste.

Access does not directly import txt data, but it can be imported with the help of Excel. First in Excel (operation in 2003 as an example): data-->> import external data-->> import data, select the txt file you want to import in the wizard, and then do the following:

Right-click on the table, select Import, select XLS as file type, open the Excel file just now, and follow the prompts step by step.

Write a small program to read each line of text, and then insert it into the database according to the delimiter (--generate an insert statement.

If it is a column, you can copy it directly, and then open the access and paste it into the specified column (if not, you can use Excel to make a pass). If there are multiple columns, it seems that there is a way to decompose them directly without knowing that they are temporarily pasted into excel, and then they are temporarily pasted into access one column at a time. If you use VB implementation, you need to find an example, which is also very simple.

In the import process, the default value of the id field is a long integer, change it to text, and you can do it.

Double-check your SQL statement and access database, this is probably not the case. Maybe it's just an extra or one less comma.

If not, don't insert it like this, read the txt file first, and then use the update statement.

Then try reading a row, then splitting the strings, and inserting them into the database one by one!