I need to import specific columns form excel into specific cloumns in access.
My problem. The columns from excel contain like 1300 records.
When I import it into access only get a few of them.
Import Wizard Details | Import Wizard enables you to easily import text ::
Import Wizard enables you to easily import text based report files into MS-Access, Excel, MS-SQL Server, MSDE, MySQL, or other databases. The software goes beyond
http://actualdownload.com/Import-Wizard_details.htmlHOME |
Download 4TOPS Excel Import for MS Access 2000 3.24 Free Trial - The ::
Download 4TOPS Excel Import for MS Access 2000 3.24 Free Trial - The easy way to import excel to access. This excel import utility is a time saving
http://www.soft32.com/download_838.html?op=5HOME |
What am I doing wrong??
Thanx
I would import into a new table, and then write a query to append the records to the existing table. You will then be able to control the data a little better. You are probably getting type conversion errors (trying to put text in a number field) or you are getting key or validation errors. Doing it this way you will be able to see the errors.
Penitaw!
WELCOME!!!
:clap:
Can't have blank rows in the excel file...
Thanks but that's not the problem. I want to import selected columns into an existing database (for web work)
My problems is I was provided a member list, and I need to integrate it to an existing table without rewriting the whole thing. When I run the wizard in doesn't let me import into an exsiting table, but makes me create a new one.
Do I create a new table and then copy the info to the correct one?
Using XP Pro and Office 2003.
Thanx for your help
 I Am a Sinner – What About You?
 Global Sourcing and Supplier Online by Dylan
|
Import an Excel to Access