insert rows - Microsoft Access / VBA

Takis

Could you please guide me how to insert 500 rows into a table?
I have Access 2003.
Thank you

Feb 2 '07 #1

Subscribe Reply

3273

Larry Linson

"Takis" <ta*******@netscape.netwrote

Could you please guide me how to insert
500 rows into a table?
I have Access 2003.

What is the source of the data you plan to insert? That would certainly
affect the recommendation on how-to. (And I can't think of any reason to
insert empty rows into a table -- rows are created as the data is entered.)

Larry Linson
Microsoft Access MVP

Feb 3 '07 #2

Takis

THank you for your replay. I've been away for 2 days.
I have a text file which is a list of directories and their contents.
It would save me alot of time if I could just copy and paste or insert
them to the data base.
I have'nt used access for long time, but somehow it is stuck in my
mind that earlier version of access had this facility, to enter a
number of rows blank, but I can't find it in the current version.
Thnks again
Peter

On Sat, 03 Feb 2007 10:08:22 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

>"Takis" <ta*******@netscape.netwrote

Could you please guide me how to insert
500 rows into a table?
I have Access 2003.

What is the source of the data you plan to insert? That would certainly
affect the recommendation on how-to. (And I can't think of any reason to
insert empty rows into a table -- rows are created as the data is entered.)

Larry Linson
Microsoft Access MVP

Feb 5 '07 #3

Similar topics

12081

Bulk insert into views that select from table on remote server

by: iqbal | last post by:

Hi all, We have an application through which we are bulk inserting rows into a view. The definition of the view is such that it selects columns from a table on a remote server. I have added the...

Microsoft SQL Server

61541

How to update if exists else Insert in one SQL statement

by: Karen Middleton | last post by:

In MS Access I can do in one SQL statement a update if exists else a insert. Assuming my source staging table is called - SOURCE and my target table is called - DEST and both of them have the...

Microsoft SQL Server

15386

Insert and Update Trigger on same Table

by: shottarum | last post by:

I currently have 2 tables as follows: CREATE TABLE . ( mhan8 int, mhac02 varchar(5), mhmot varchar(5), mhupmj int )

Microsoft SQL Server

3844

update transmogrifies to insert/delete

by: robert | last post by:

been ruminating on the question (mostly in a 390/v7 context) of whether, and if so when, a row update becomes an insert/delete. i assume that there is a threshold on the number of columns of the...

DB2 Database

9167

PostgreSQL insert speed tests

by: Sezai YILMAZ | last post by:

Hello I need high throughput while inserting into PostgreSQL. Because of that I did some PostgreSQL insert performance tests. ------------------------------------------------------------ --...

PostgreSQL Database

18310

most idiomatic way to "update or insert"?

by: Mark Harrison | last post by:

So I have some data that I want to put into a table. If the row already exists (as defined by the primary key), I would like to update the row. Otherwise, I would like to insert the row. I've...

PostgreSQL Database

2894

Question regarding CLI array Insert

by: Michel Esber | last post by:

Hello, Environment: db2 V8 FP 13 LUW Our application currently uses: insert into table values ('A'),('B'),...('Z') We have used CLI arrays inserts (1000 array and commit size) and...

DB2 Database

4832

datagridview source Tbl - cant Insert/Delete on same process?

by: =?Utf-8?B?UmljaA==?= | last post by:

On a form - I have a datagridview which is docked to the entire form. The datagridview allows users to Delete and/or Add Rows. On the Form_Load event I Fill the datagridview source table with a...

Visual Basic .NET

3706

Multitable insert in DB2 v8 os no Merge is avilable:

by: lenygold via DBMonster.com | last post by:

Hi everybody: What is the best way to I have 10 tables with similar INSERT requiremnts. INSERT INTO ACSB.VAATAFAE WITH AA(AA_TIN, AA_FILE_SOURCE_CD, .AA_TIN_TYP) AS ( SELECT AA_TIN,...

DB2 Database

2642

SPROC help for insert into from related records

by: EJO | last post by:

with sql 2000 enterprise Trying to build a stored procedure that will take the rows of a parent table, insert them into another table as well as the rows from a child table to insert into...

Microsoft SQL Server

7207

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7093

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7291

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7357

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

5598

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5023

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

1522

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

748

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

402

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General