Hi Athersgeo,

Believe it or not, this is a feature of SSIS. The best way to handle flat file importing is mapping the flat file connection EXACTLY the way the file is mapped and configuring the...

Hmm...I've done some beginner level java programming, do they by chance have an ADODB Recordset object? You could load records into the object then push those records into the table when batch...

Hi there.

Have you by chance attemped any type of batching? I'd queue up the record and try to batch them first, say 50,000 recs for each batch? See if that makes things any easier and let us...

This old function I made may help as it demonstrates the concepts of looping with SQL (without a yucky cursor!).

CREATE function [dbo].[fn_Is_Uppercase]
(@string varchar(1000))
returns bit...

Additionally, if you have to perform this task any more, its quite easy to build a SSIS package to do it for you. That way having a fresh new Access DB is only a click away.

Wow. Few issues I noticed with this:

1. There is no group by clause. You'll want to group by Cardno and cardeventdate when trying to aggregate.
2. Look out in your where clause!!
2A. You...

This (http://msdn.microsoft.com/en-us/library/ms189461.aspx) may correct the issue if implemented correctly, and at the same time eliminate the need of your functions.

To correct the function and...

Look through the metadata functions available in your database.

Specifically, the columnproperty() function looks like it may be of some use for you.

As suggested earlier the question was a...

Hi,

Could you provide us with a few sample rows of data. SSIS/DTS should be able to do the trick (commonly work with CSV data), we just need to see the data so we can put you in the right...

You can use SMO to look through each table in a given database and code SSIS to only export those that have a rowcount.

This kind of functionality is easy in theory but I'm not quite a SSIS ninja...

You need to use the logic in the SP to concatenate a dynamic SQL query, then execute the query.

Right now you know your parameter is going in right, you just now have to concatenate properly and...

I have a feeling you're going to have to use a cursor to get that kind of result. Read up on them, it should be pretty easy, but keep in mind they are a bit slow if you're using a lot of data.

Hi Tripsturr,

I'd recommend keeping the words on a MSSQL backend (or Access) if you want to have the ability to keep adding them. If you're not familiar with databases you can always use an XML...

Kav,

Change your cmd to this:


cmd = New OleDbCommand("Select * from table1 Where Mfg Like %'" & ComboBox1.SelectedItem & "'% And Make Like %'" & ComboBox2.SelectedItem & "'% And RAM Like %'"...

You could configure and adjust SSIS packages every time you add a table, for all 6 databases...or you could replicate (most practical solution IMO).

To do this properly, I would focus on allowing the user to select their birthdate with a datetimepicker....or, convert their choices from your listboxes to a date.

You will need to insert error...

I'm not sure what you're talking about doing exactly, but when I talked to Integrated Circuits via the Serial Port I used the System.IO.Ports Namespace.

Check the "Base Class Libraries - Group 2...

Can you post your own in a PDF or JPG so we can help you with it?

This should do the trick :) Although inefficient, I used self-left outer joins and the isnull function to give us a 0 value for quantity.

+++++++++++++++++++++++++
Name + Apple + Banana + Pine +...

Ok you're getting an error with this statement
"viewList = CPDB.GetViewList"

You're trying to convert something that isn't a string into one implicitly here. If you can't do so explicitly (like...

You should use a connection and a query to find all the models of a particular make, then populate the model combobox on the closeup or indexchanged event on the make combobox.

Hello,

If you're getting a recordset back with no data that is an indicator that something is wrong with your SQL syntax.

I'd put a break in the code and see exactly what string you are passing...

Most times we use recordset objects to read from datasources. We do this by:

1. Instantiating the connection
2. Instantiating the recordset object
3. Determining what data we want returned
4....

"SELECT [Database], [Date], [User] FROM [View] ORDER BY [Database]"


Try that and see if it works. I'm assuming you have a table or a view with the name of "View", and columns within this...

Hi Vikrant,

Frist you need to connect to your Access Database via a connection string (http://www.connectionstrings.com).

Once you're there, the easiest way of doing it (since Access seems to...

Hi Aks,

The answer to your question is yes.

Here (http://www.codeproject.com/KB/vb/Work_with_Excel__VBNET_.aspx) is a link to some sample code. Let us know how it works out :)

Matiman,

Keep in mind some (actually most) hosting companies will only allow access to their SQL servers from their host machines. This is so they don't grant everyone on the internet the ability...

It looks like your SQL syntax is incorrect. Read up on INSERT syntax here (http://en.wikipedia.org/wiki/Insert_%28SQL%29).

Please keep us updated on your progress/trial & error.

Peter,

It seemed his/her question was pretty straight forward and geared towards flat files and text manipulation. You earlier replied with "I do not understand what this has to do with...

Ok...If this is working without the order by try this.

1. Remove the order by on both SQL statements
2. Turn the unioned set into a sub statement...something like:

Select * from
(Select...

Indeed...your error is coming from 1. lack of a filename in the connection string and 2. no driver specified. That should fix it as long as you can successfully modify it.

Try something like this for your connection string.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

That was from www.connectionstrings.com

I think [Records Ordered by rowID] could be part of a view which may not be updatable (includes deletion).

The invalid syntax is coming from the 'go' you have in between the union. 'go' is making SQL go do its work and it starts the next command with 'union all' and is probably wondering what to union.
...

Yes...keep in mind you can't do arithmitic operations with null values.

I'd suggest using a view or a stored procedure. The syntax would be something like the following.

SELECT Dayofweek, MAX(Timeslot) as 'Timeslot', MAX(AM/PM) as 'AM/PM', MAX(Description) as...

I think you should look into using DTS or SSIS (depending on SQL version) to bring the information in, then export it out.

This is a 5 minute job if you're familiar with DTS or SSIS.

Yes. I'm not sure why you're not getting some type of exception thrown if its unable to reach the DB, perhaps you have coded around this possibility or there is something missing.

Make sure you...

Hi there Ibanez

You'll probably want to look into clickonce deployment, which you can use to deploy your application to a UNC/URL and let the clients install.

The framework can easily be...

I'm pretty sure you can. Look into executing DTS scripts from the command promt, then copy whatever you find necessary from the prompt and use it in a shell command.