ACCESS FEED: Re: [MS_AccessPros] Re: Importing from CSV file

Selasa, 27 Oktober 2015

Re: [MS_AccessPros] Re: Importing from CSV file

Thanks again, Crystal! I'm pretty sure now that the problem is that one of the other fields is required, but my computer isn't working just now, so I can't check it. If that is not the case, I'll get back with more info.

James
www.james-mc.com
Words To Live By

On Oct 27, 2015, 12:08 AM -0500, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>, wrote:

Hi James,

What other fields are in the table? Anything required? Does County allow ZLS (zero-length string)?

maybe add criteria to your query -- WHERE len(trim(nz(County,""))) > 0

> "The County fields in both tables are both the same type: text. "

what is the SIZE property of the fields?

If you still don't get it, could you possibly post a sample so we can see what is happening?

thanks

warm regards,
crystal

Tool: Document Query Calculated Fields: Access to Excel. Music by JD Live (cc)
https://www.youtube.com/watch?v=vS8KfHU6L90
- SQL to show calculated fields in queries, use CopyFromRecordset to put in Excel and then format

~ have an awesome day ~

On 10/26/2015 10:11 PM, James McAlister kc5qeg@gmail.com [MS_Access_Professionals] wrote:

Thanks, Crystal!

There are no autonumber fields involved, and my query has just a single field right now to get the basic syntax right. It's the third field in the order in both tables, and both are typed as text. so it sounds like I'm doing what you describe, but nothing is being imported.

James
www.james-mc.com
Words To Live By

On Oct 26, 2015, 10:52 PM -0500, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>, wrote:

Hi James,

if you have an AutoNumber or other fields that are not in the import information, move them to the end of the order ... or use a query that doesn't include them. Fields must be in the same order as what you are bringing in.

warm regards,
crystal

Document Query SQL, Form and Report RecordSources
http://www.rogersaccesslibrary.com/forum/document-query-sql-form-and-report-recordsources_topic606.html
Create Word documents with SQL for queries, form and report RecordSources, and make a query showing database objects

~ have an awesome day ~

On 10/26/2015 5:33 PM, James McAlister kc5qeg@gmail.com [MS_Access_Professionals] wrote:

Just a little more info that points to some basic error I'm making which I hope someone will gently point out. :-)

With the RawData table (only 100 records right now) linked, I'm trying to import just a single field into Import for test:

INSERT INTO Import ( County )

SELECT County

FROM RawData;

Running the query indicates that all 100 records are about to be appended, but 0 records actually get appended due to type conversion error. The County fields in both tables are both the same type: text.

So what am I doing wrong? I feel kinda dumb right now. :-(

Thanks!

On Mon, Oct 26, 2015 at 5:12 PM, James McAlister <kc5qeg@gmail.com> wrote:

I have a database with one main table, Import, which currently has no records. I also have a file, RawData.csv, with about 1.7 million records and 171 fields. What I'd like to do is import all of the records but only a fraction of the fields from RawData.csv into the Import table. In the past I have just used the Import feature (External Data tab) to quickly pull in all of the fields from RawData, but since the resulting database size approaches the 2GB limit, I'd like to limit the import to about 150 of the fields that I really need.

How should I go about this? I've set up a linked table to RawData.csv is case that would be needed.

I'm using Access 2010 on Windows 10.

Thanks for any help!

James