Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / September 2007

Tip: Looking for answers? Try searching our database.

import csv and parse?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave - 12 Sep 2007 18:44 GMT
Hi everyone,

You've been a great help to me in the past. I hope someone can here
too.

I have a database to which I would like to import data from a csv
file. Each csv file has about 30 different fields separated by commas.
I want to add only two of those fields to my database. How do I do
this? Or does somebody know of a tutorial that might help?

Thanks,

Dave B
Pieter Wijnen - 12 Sep 2007 20:10 GMT
You can make an import spec & skip the fields that way - or - import into a
temp table & run an Append query on that

Pieter

> Hi everyone,
>
[quoted text clipped - 9 lines]
>
> Dave B
Albert D. Kallal - 13 Sep 2007 02:18 GMT
the import wizard lets you exclude columns during a import....

file->get external data->import

when the wizard starts, select comma, delimiters etc....

Then hit the advanced button..you see a check mark to include only the
fields you want...

So, once you get this working via a manual process, then you can save this
'advanced' setting, and make the whole process a one button click affair
(note the "save-as" buttion in the advanced setting, this is how you "save"
your import spec..and once done, you can use this with the transfertext
command to automate the import).

So, take this one step at a time, save the import spec, and get the text
import working the way you want...

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Dave - 13 Sep 2007 12:48 GMT
On Sep 12, 9:18 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
> the import wizard lets you exclude columns during a import....
>
[quoted text clipped - 18 lines]
> Edmonton, Alberta Canada
> pleaseNOOSpamKal...@msn.com

Thanks Albert, you're always so helpful.

How about if it is an excel spreadsheet instead of a csv file. Is
there a way to automate the import of that? I found out that the
instrument output that I'm interested in importing to my database,
exports as a excel file, not text unfortunately.

Thanks,

Dave B
Pieter Wijnen - 13 Sep 2007 15:59 GMT
I think you have to use a temporary table (or link to the spreadsheet)
& import to the real table using a Query

Pieter

> On Sep 12, 9:18 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
> wrote:
[quoted text clipped - 33 lines]
>
> Dave B
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.