--TripWire--
asked on
Using SQL's INSERT INTO in Access
I have a very simple question.
I have a comma-delimited text file (created from an Excel spreadsheet)
and I want to insert the values into an MDB.
BUT, I want to be able to specify which values go into which field into my MDB's table.
I've done this before with SQL server on a larger scale, but since this computer is a server, I don't want to have to download a large app like that.
Can I use SQL's INSERT INTO command just using Access 2002/2003?
Thanks
I have a comma-delimited text file (created from an Excel spreadsheet)
and I want to insert the values into an MDB.
BUT, I want to be able to specify which values go into which field into my MDB's table.
I've done this before with SQL server on a larger scale, but since this computer is a server, I don't want to have to download a large app like that.
Can I use SQL's INSERT INTO command just using Access 2002/2003?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Tripwire,
Is this a onetime task or will be repeating this process on a regular basis.
If a one time thing you can do it manually. Look at LSMConsulting's recommendation.
If the will be repeated, I will use a form. In a command button with VbA code to use Helen's recommendation. .
Is this a onetime task or will be repeating this process on a regular basis.
If a one time thing you can do it manually. Look at LSMConsulting's recommendation.
If the will be repeated, I will use a form. In a command button with VbA code to use Helen's recommendation. .
ASKER
Hello,
This will be a one time task. I need to group about 2-300 records and import them into an existing MDB.
This will be a one time task. I need to group about 2-300 records and import them into an existing MDB.
ASKER
Anybody know of any good step-by-step How-To pages for this?
ASKER
Thanks for your answer - but the problem with that is I only want SOME columns to be imported. The rest are irrelevant to the table.
Also, the table I wan to import the values into has an autonumber as it's PK. Is there a way to autopopulate that column so the DB doesn't cry foul on lack of PK values?
Also, the table I wan to import the values into has an autonumber as it's PK. Is there a way to autopopulate that column so the DB doesn't cry foul on lack of PK values?
ASKER
An error occured trying to import file "C:zzz.xls." the file was not imported.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
See my comment above - it's not importing at all.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, that series worked.
Just a side note, I had some Type Conversion errors at first, but to solve that, I had to go into my spreadsheet and perform what's outlined in this link....
http://support.microsoft.c om/kb/1093 76
Just a side note, I had some Type Conversion errors at first, but to solve that, I had to go into my spreadsheet and perform what's outlined in this link....
http://support.microsoft.c
You can import the whole sheet (or range) to a table of raw data, and then use a Select query to select the columns you need, and do data type conversion as needed.
ASKER
Thanks for the info, but the articles deals in rows and is probably less work.
But I will definitely try your method as well.
But I will definitely try your method as well.
ASKER
Can someone please give me some advice on my latest requirement? Thanks
http://www.experts-exchang e.com/Micr osoft/Deve lopment/MS _Access/Q_ 26874699.h tml
http://www.experts-exchang
ASKER
In somewhere the Macro?