Export data from excell to access

  • Thread starter Thread starter chooriang
  • Start date Start date
C

chooriang

Hi,I am Cho
I wanna asking something.In access can we specified the number of rows in a
column.I want to insert 1800 rows at once,or how to copy and paste 1800
excell cells which contain various value into a column of access table.Can I
make it,is it possible,Please advise

Regards,
Cho
 
learn an ETL tool

SQL Server DTS or Informatica or SQL Server 2005 Integration Services
or something

good luck

-Aaron
 
Hi,I am Cho
I wanna asking something.In access can we specified the number of rows in a
column.I want to insert 1800 rows at once,or how to copy and paste 1800
excell cells which contain various value into a column of access table.Can I
make it,is it possible,Please advise

Regards,
Cho
Click to expand...

The simplest way is to use File... Get External Data... Link to link
to the Excel spreadsheet, and run an Append query to append the
spreadsheet records into your Table.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete formula without deleting the result ( yield ) 1
2007 Data Export Limit 2
New record overwritten on old column 5
access report through excel 1
Exporting to Excel from Access 3
Excel Import Into Access 3
VBA - retrieve data on last create named range from previous inserted named range 0
INSERT to excel file 4

Back
Top